Attach ActiveX script to package through VB6.0greenspun.com : LUSENET : SQL Server Database Administration : One Thread
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
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,
-- Anonymous, October 04, 2004