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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to generate a script for DTS packages

Author  Topic 

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2009-09-10 : 19:28:26
Hi All,

Can u pls let me knw how to generate a script for DTS packages.Is there any tools available to generate DTS scripts ?...

Thanks & regards
Ravi


Thanks & Regards

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-09-11 : 00:44:00
Go into Design mode on the package, choose Save As, and change the file type to Structured File. After you save it you can import it to another server, or archive it using normal file copy.
Go to Top of Page

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2009-09-11 : 12:06:39
quote:
Originally posted by robvolk

Go into Design mode on the package, choose Save As, and change the file type to Structured File. After you save it you can import it to another server, or archive it using normal file copy.



Hi Rob,

Yep,i got it., :-)

Thanks Again...

Regards
Ravi

Thanks & Regards
Go to Top of Page
   

- Advertisement -