I have a fully functional DTS Package that I want to load into a new database environment using SQL Query Analyzer. Does anyone know how to accomplish this task? I know this can be done using Enterprise manager, but I must have it in a script that can be executed in Query Analyzer. Please advice. Thanks.
Why must this be done in Query Analyzer? If the two servers have the ability to connect to each other, you could use sysdtspackages but I don't believe this is the supported option as you are using undocumented system tables. However, you can find information on using this table to move the package in this article: http://www.sqldts.com/204.aspx
Other methods of moving packages are discussed in the article as well. If this is a requirement to move something to production or follow some other promotion or release guidelines, you may want to try to pursue saving the package as a structured storage files. The article addresses how to do this as well. And this method would be supported.
-Sue
No comments:
Post a Comment