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 appreciatedI 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
hp
]]>