using DTS Connection in ActX Script

• Danny Street

  Newbie

  Points: 1

  More actions

  December 19, 2006 at 2:22 am

  #67822

  Apologies in advance for an old topic...

  I want to use a DTS Connection to execute SQL. I read the solution on a thread, indicating to create an ADODB connection using the DTS Connection properties.

  However the password is Write only. It is not possible to read it.

  Can someone advise?

• December 22, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Sherri Garriott

  SSC Rookie

  Points: 25

  More actions

  December 22, 2006 at 10:18 am

  #679780

  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