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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2006-02-13 : 09:57:28
|
| I saved a DTS package as a VB file instead of Structured Storage File. I then tried to open the VB file in DTS Designer, but I got "specified file is not a package storage file" error message.Does anyone experience it or know how to open a VB file in DTS Designer in Enterprise Manager?Thanks,Ben |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-02-15 : 16:11:28
|
| I don't think you can. Found a post on another SQL site. "look for the line goPackage.Execute. Just before this is a commented out line to save the package to the server. Uncomment the save line and comment out the Execute line. You'll also need to edit the save line to have your Server name and login details. Then run the .bas file in VB." |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-15 : 16:35:27
|
| Saving the package as a VB file is so that you can grab the code to be used in your application. It saves you time when performing the DTS work via your application. So if you want to do this from Enterprise Manager, then it can either be a structured storage file or a package stored in msdb. Otherwise, you have to use VB.Tara Kizeraka tduggan |
|
|
|
|
|
|
Open VB file