DTS Connection | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Connection

Hi,
I’m creating a activeX script in DTS and using a recordset object.
how can i set the connection property of rs to be
rs.activeconnection=DTSGlobalVariables.Parent.Connections("CN")
i.e. how can i use the connection i created outside script in DTS.
May check
http://www.databasejournal.com/features/mssql/article.php/3100661
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/dts2000inaction.asp Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
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.
]]>