Posts
1150
Comments
891
Trackbacks
1
T-SQL: Using Microsoft Office Applications to Edit/Run/Debug DTS Packages

From Doug Waldron.

For instance, using Microsoft Word:

Save the DTS package to the file system.

 

Tools->Macro->Visual Basic Editor

Pops a Visual Basic 6 Window.

View->code

Cut and past your code into the new window

Tools->References

 

check Microsoft DTSPackage Object Libray

 

check Microsoft DTS Custome Tasks Object Library

 

check Microsoft DTSDataPump Scripting Object Library

 

 

 

F8 to step through

 

F9 to set break point

 

F5 to run

posted on Friday, July 27, 2007 1:59 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 7 and 1 and type the answer here: