I'm creating a DTS package through Visual Basic 6.0 and I have a bulky ActiveX script to be included in the package. Instead of writing the whole script into a string variable and then rewriting the ActiveX script at the time of creation of the package i want to attach the .bas file to the package at run time. Can I do it? I will very grateful if you can help me out.

-- Anonymous, September 28, 2004

Answers

Padmaja,

Try the technique described in the SQL Server Books Online topic, "How to add ActiveX workflow scripts in DTS Designer (Enterprise Manager)".

Hope this helps,

Eric

-- Anonymous, October 04, 2004