Friday, February 17, 2012

Creating DTS

Is there a way to create a DTS(Data transformation services) from Windows application ?

And how can I send parameters to DTS from my CSharp Code ?

ThanksDTS is based around a COM object model, so any COM compatible programming language can be used to leverage this object model and therefore build, and execute a package.

You can create SSIS packages in code as well.

Rather than writing your own application why not use Enterprise Manager for DTS or Business Intelligence Development Studio for SSIS?|||Cause at my work we do not have Business Intelligence Development Studio, And I don't know how SSIS works,....

I Have a dll to work with DTS but I don't know how to send the parameters....

I downloaded from http://www.sqldts.com/

Any sugestion ?|||Are you really asking about DTS for SQL Server 2000? My confusion arises because this is a forum for SSIS and not DTS, the title indicates that.

How is this DLL expected to work with DTS? What is it?

If you downloaded the DLL from SQLDTS, what DLL is that from the site?|||UHUn It's DTS for SQL 2000

It's a class that I can call DTS from SQL Server or a file .dts|||So where did this class come from?

dtspkg.dll is a DLL from MS that allows you to load and then execute a DTS package.|||Is this one that I'm using

No comments:

Post a Comment