September 23, 2009 at 2:33 am
If you have a SQL 2000 DTS package, can you execute the package in Query
Analyzer without having to use Enterprise Manager and without having to
right-click on the package?
September 23, 2009 at 2:35 am
yes , u can execute it !!
September 23, 2009 at 2:40 am
can u pls provide the command.?
September 23, 2009 at 2:46 am
charipg (9/23/2009)
If you have a SQL 2000 DTS package, can you execute the package in QueryAnalyzer without having to use Enterprise Manager and without having to
right-click on the package?
You can do, but it isnt advisable, you can use xp_cmdshell and use dtsrun and specify the dts package.
but if it goes wrong, you run the risk of having to do a reboot.
better to run it via a sql job
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 23, 2009 at 3:30 am
Silverfox (9/23/2009)
charipg (9/23/2009)
If you have a SQL 2000 DTS package, can you execute the package in QueryAnalyzer without having to use Enterprise Manager and without having to
right-click on the package?
You can do, but it isnt advisable, you can use xp_cmdshell and use dtsrun and specify the dts package.
but if it goes wrong, you run the risk of having to do a reboot.
better to run it via a sql job
You shouldn't have to do a reboot, but you may need to use Task Manager to kill some dtsrun.exe commands that are waiting for inputs..
CEWII
September 23, 2009 at 3:41 am
Elliott W (9/23/2009)
Silverfox (9/23/2009)
charipg (9/23/2009)
If you have a SQL 2000 DTS package, can you execute the package in QueryAnalyzer without having to use Enterprise Manager and without having to
right-click on the package?
You can do, but it isnt advisable, you can use xp_cmdshell and use dtsrun and specify the dts package.
but if it goes wrong, you run the risk of having to do a reboot.
better to run it via a sql job
You shouldn't have to do a reboot, but you may need to use Task Manager to kill some dtsrun.exe commands that are waiting for inputs..
CEWII
I did say 'You run the risk' 😛 and depending on what other processes are spawned from running the dts package, killing the dtsrun.exe process might not solve everything.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 23, 2009 at 11:04 am
My experience suggests it usually will, it will even abort the cmd.exe that called it.. There are very few cases it won't and all of them are execute process tasks and execute package tasks.
CEWII
September 24, 2009 at 1:08 pm
Use xp_cmdshell for running the followng command:
DTSRun /S "server name" /N "dts name" /W "0" /E
MJ
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply