Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
YellowBug
Aged Yak Warrior
616 Posts |
 Posted - 2003-03-04 : 05:18:48
|
| How do I save all my DTS Packages to VB files (*.bas) programmatically?The package2 object does not appear to have a SaveToVisualBasicFile method, or am I missing something?We have loads of packages, and would like to save them all to VB files, so that we can then search for a text string (e.g. SERVERNAME). Thanks |
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-03-04 : 06:36:14
|
| Quote from BOL"The SaveToRepositoryAs, SaveToSQLServerAs, and SaveToStorageFileAs methods assign a new name and package ID to a Package2 object, and then save it to the specified persistent storage."Check BOL for following methods SaveToStorageFileAs. That shd do the jobHTHSamrat |
 |
|
|
|
|
|
SQL 2000 - DTS Package SaveAs Visual Basic File