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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2007-09-14 : 14:34:07
|
| 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. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-14 : 15:21:55
|
| you can use DTSRun and xp_cmdshell to run it..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-15 : 00:38:26
|
| Or make it a sql job then rnu it with msdb..sp_start_job. |
|
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2007-09-16 : 17:23:20
|
| Thanks for the reply folks, but I'm looking for a script that can load the DTS package that was created in a different environment into a totallyh different environment by using Query Analyzer. Please advice. Thanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-16 : 17:54:32
|
| Can't think of any method. |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2007-09-19 : 16:41:29
|
| One of the problems with this is that you could potentially execute the DTS package on the machine that the DTS package was written for. If your DTS Package has a connection definition(or several) that is static then even if you do manage to execute the DTS package, it will be hitting the original database. |
|
|
|
|
|
|
How to load a DTS package using SQL Query Analyzer