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 |
|
lphillip
Starting Member
2 Posts |
 Posted - 2006-01-09 : 12:16:42
|
| I have saved my dts as a vb file, made changes and now I want to open it again using Enterprise Manager. How can I do this? |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-01-09 : 12:20:02
|
| have you right clicked on the Data Transformation Services Category header and tried opening the package?just a thought.________________________________________________The only cure for thinking is picking rocks, or drinking beer. |
 |
|
|
lphillip
Starting Member
2 Posts |
Posted - 2006-01-09 : 14:06:17
|
Yes, I already tried to open it, but it's asking for a structured storage file. It doesn't recognize the .bas file.quote:
Originally posted by Vivaldi
have you right clicked on the Data Transformation Services Category header and tried opening the package?just a thought.________________________________________________The only cure for thinking is picking rocks, or drinking beer.
|
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-01-09 : 15:22:37
|
quote:
Originally posted by lphillip
I have saved my dts as a vb file, made changes and now I want to open it again using Enterprise Manager. How can I do this?
Since you saved it as a VB file, you will have to open it with Visual Basic.Saving it as a .BAS file is only meant for when you want to include DTS code in a VB app. For normal DTS work, you should save it in the database, or as a structured storage file.CODO ERGO SUM |
|
|
|
|
|
|
SQL DTS