Execute Process Task | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Execute Process Task

Can this be achieved. 1. I want to create a DTS which will execute a bat file on remote server. Meaning I will execute the DTS on Server A which does not have WinZip installed on it. This DTS has "Execute Process Task" which will point to a Batch file on Server B which inturn has the Command Line command to Zip a file and save it on Server B. Can this be achieved using DTS ? I do not have SQL Server installed on Server B and do not have Win Zip installed on Server A to run the batch file on Server A Any thoughts are appreciated
I first guess would be to use an ExecuteSQL task in the DTS package on Server A and run xp_cmdshell to execute the batch file stored in Server B granted you have the proper permissions set up. Raulie