I found this URL that may help.

http://groups.google.com/group/microsoft.public.sqlserver.dts/browse_thread/thread/b0866c966b639e35/b8ea4a59d565fee2?lnk=st&q=create+an+ADODB+connection+using+the+DTS+Connection+properties&rnum=5#b8ea4a59d565fee2