running a command line prompt from a dts package 2

[collierd]

Hello

I am using SQL Server 2000 on windows NT

Does anybody know the easiest way to automate the execution of a command from the dos prompt once a package has completed?

Thanks

Damian.

 

[cdukes]

Create a batch file to run your command from the dos shell, then call it from the DTS package by creating an 'Execute Process Task', Specifying the name of the batch file.

Hope this helps,

Chris Dukes

 

[JayKusch]

as your last step in the DTS package youv'e created ... add a "Execute SQL Task" and in the SQL Statement box use the xp_xmdshell to do your DOS task. Thanks

J. Kusch

 

[JayKusch]

Sorry ... that was xp_cmdshell .... NOT xp_xmdshell. fat fingers this morning! Thanks

J. Kusch

 

[cdukes]

JayKusch,

Although a solution, I would not suggest using the xp_cmdshell due to the power and security issues with xp_cmdshell.

Chris Dukes

 

[collierd]

Thanks

Both worked will roll the batch file method