|
Subject:
|
Save DTS Package as Visual Basic File
|
|
Posted By:
|
vishpala_kadam
|
Post Date:
|
1/10/2006 5:10:52 AM
|
Hi,
I have writen a VB program to save all the DTS packages on the server in '.dat' format.
I want to do the same to save them in Visual Basic Format(.bas) .
Any pointers to how to acieve?
Thanks
|
|
Reply By:
|
David_the_DBA
|
Reply Date:
|
1/10/2006 11:34:56 AM
|
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
|
