have you checked out the help and support for your SQL package?

check out this link

http://www.15seconds.com/issue/030909.htm

(looks like its written in some VB though, but easily transferrable to C#)

http://www.c-sharpcorner.com/UploadF...AM/DTSnCS.aspx

and this link

http://www.connectionstrings.com/

which contains a list of known SQL/Database types and how to connect to them via most languages.

just do a google search of

sql dts c#

a lot of excellent links pop up.