DTS Connection | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Connection

I’m creating a activeX script in DTS and using a recordset object.
how can i set the connection property of rs to be
i.e. how can i use the connection i created outside script in DTS.
May check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/dts2000inaction.asp Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya,
The links are good but dont’ have information which i need.
I want to create a connection object in my activex script but the login information i need from the connection i made out of script in DTS So how to get that information.
Or else instead of creating new cn object how can i use the connection which i have made in DTS but out of script.