Posts
1150
Comments
891
Trackbacks
1
Sql Server: Promoting .bas files into DTS packages using Microsoft Word

Delete the package on the destination server if it already exists.

Open DTS package (design)
Save As, Location Visual Basic File
Edit visual basic file, .bas to make changes
use these next lines to save to database and comment out execute
goPackage.SaveToSQLServer “servername", , , 256  ' you can also use sa authentication
'goPackage.Execute

To load
Open MS Word
Tools->Macros->Visual Basic editor
Cut and paste .bas file into editor

Tools->References  
            check Microsoft DTSPackage Object Libray
            check Microsoft DTS Custome Tasks Object Library
            check Microsoft DTSDataPump Scripting Object Library

F5 to run

 

posted on Friday, September 15, 2006 3:25 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 2 and 4 and type the answer here: