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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2009-01-05 : 03:54:28
|
| is there a way, from windows 2005 to run an imported DTS of windows 2000 withought using the CMDSHELL command?** currently the DTS is activated from a Stroed ProcedureThanks in advancePelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-01-08 : 07:21:52
|
| Does running cmdshell inside a stored procedure help or do you want to do without cmdshell totally?This way you can run DTS by passing in DTSBName into proc.CREATE proc [dbo].[s_RunDTS] @DTSName as varchar (250)ASDECLARE @cmd as varchar (1000)SELECT @cmd = 'dtsrun /S "(local)" /U DTS_User /P DTS_User_Password /N "' + @DTSName + '"'EXEC master..xp_cmdshell @cmd |
 |
|
|
|
|
|
running a DTS withought using CMDSHELL command