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 |
|
BitShift
Yak Posting Veteran
98 Posts |
 Posted - 2007-02-13 : 16:15:06
|
| Im running Sql 2005 and Visual studio 2005. I have an older DTS package that I would like to debug by stepping line by line though the vbscript code. How can I do it ?I can, for example save the vbscript code to a file, then launch visual studio in a script debugging session withC:>cscript file_name.vbs //XThe only problem with this is the references to the DTS-specific enviroment objects and properties arent available unless the script is running within the DTS enviroment.Suggestions ? |
|
|
ekb18c
Starting Member
18 Posts |
Posted - 2007-02-14 : 23:52:54
|
| Save the DTS as a file storeage(save from sql 2000). Import that dts package into SQL Server 2005? Make sure you have the DTS runtime. That way it behaves just like a DTS package in sql 2005. You can debug from SSMS. Management-->Legacy-->DTSwww.sqlnerd.com |
 |
|
|
|
|
|
debugging dts package