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 |
|
CanadaDBA
583 Posts |
 Posted - 2004-10-07 : 09:36:51
|
| I am going to change a DTS package but I want to script current DTS to be able to recover it in case of an emergency. How can I script a DTS package?Canada DBA |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-10-07 : 09:41:22
|
| Open the package in design mode and click on <Package><Save As> and select <Structured SDtorage File > for location. |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-10-07 : 09:43:14
|
| Right Click the DTS package and select versions !!.- Sekar |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-07 : 10:44:27
|
Using your suggestion, I saved a .dts file. I opened the file with Notepad but seems it is not a text file. How can I use it again?Thanks,quote:
Originally posted by ehorn
Open the package in design mode and click on <Package><Save As> and select <Structured SDtorage File > for location.
Canada DBA |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-10-07 : 10:46:14
|
| You have to open it in Enterprise manager. Right click on Data Transformation Services tab and select <Open Packages> then point tO the file. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-07 : 11:12:11
|
First I was confused with your reply but after I test it, I found it a very clever suggestion. Thank you!It seems SQL-Server keeps all versions of a DTS package. So, I can load previous one whenever I want. Am I right?quote:
Originally posted by samsekar
Right Click the DTS package and select versions !!.- Sekar
Canada DBA |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-10-07 : 11:16:50
|
| The SQL Server will maintain the versions whenever you save the package either in file or in SQL Server. In EM if you want to edit a previous version, right click the dts package select the previous version & choose edit !Simillarly When you open the dts file in EM it will prompt you to select the versions where you can choose to edit.HTH..- Sekar |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-07 : 11:18:26
|
Thanks Jay, I have a solution for my problem now but I continue to learn your suggestion. I was able to open the package but when I save it and close it and then re-open the DTS, the previous one appears not the one that I had saved from .dts file. How can I replace the .dts file with the current DTS package? quote:
Originally posted by ehorn
You have to open it in Enterprise manager. Right click on Data Transformation Services tab and select <Open Packages> then point tO the file.
Canada DBA |
|
|
|
|
|
|
Script a DTS package