There was a utility (
vb 6 code) to save out packages in
vb that was included on the SQL 7 CD. It works with 2000 but with several caveats.
1) The utility uses the DTS 1.0 model not the new DTS 2.0 model that SQL 2000 uses so you can save it out to
VB but it won't necessarily work the same way -- and it won't match what you get if you do it by hand.
As far as I have been able to determine no one has publicly put forth a utility to do it, but I have not look for such a utility in almost 8 months.
David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Save DTS Package as Visual Basic File
