does anybody know whether i can write a simple connection string within DTS activex script task?
i have various function that uses the same connection. I find myself typing this a lot
'Create and initialize (Open) ADO Connection
Set objADOCnn = CreateObject("ADODB.Connection")