In article <08F853CE-19E2-4F30-BF55-B0494433B663 (AT) microsoft (DOT) com>, Dwaine wrote:
Quote:
In SQL 7 days we had scriptpkg which taught us a lot about DTS.
In SQL 2000 it's built in as the Save As... of DTS designer, but no mention
of how to access the functionality programatically. How do I get to it?
Another option would be converting ScriptPkg to a .NET version, I've tried
but don't have time now to debug...
any help, suggestions would be appreciated |
There is no programmatic way to save to VB Module in the DTS Object model.
Can you not use ScriptPKG?
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know