DTS transfers using C sharp ( sql server )

[hbartow]

I'm trying to convert a small vb program to csharp which uses sql server DTS objects.

In VB, I add the 'Microsoft DTSPackage Object Library' under project/references and am able to use the DTS transfer objects in my vb program.

I've converted the code to c sharp ( i think ), but don't know how to go about adding this library/dll to my c sharp program.

Any ideas? Thank you.

 

[obislavu]

You will find the same in C#:
Solution Explorer-> right click on References-> scroll in the COM tab and select above Package and the DTS entry will be added in the References tree.
-obislavu-

 

[hbartow]

thanks. I currently don't use Visual Studio. do you know how to do this using a standard text editor and the .net sdk? Thanks.

 

[obislavu]

You should have access/registered the dtspkg.dll and link with this dll :
csc Class1.cs
csc /target:library MyLib.cs
csc /reference:MyLib.dll dtspkg.dll
csc ...

-obislavu-