Error In Execute Process Task (ssis)
[Execute Process Task] Progress: Operation Complete - 0 percent complete [Execute Process Task] Error: In Executing "C:\Program Files\7-Zip\7z.exe" "e "H:\sathiya\sqlfile\SSIS\P_Packages\2\SRC\test.zip" -o"H:\sathiya\sqlfile\SSIS\P_Packages\2\SRC\" -y" at "", The process exit code was "2" while the expected was "0". [Execute Process Task] Progress: Operation Complete - 100 percent complete Task Execute Process Task failed
July 25th, 2012 3:37am

It's a 7z error: http://sevenzip.sourceforge.jp/chm/cmdline/exit_codes.htm Have you tested the command outside ssis? Are you running it as a job or within BIDS? Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2012 3:45am

Hi, I have tested in BIDS only . May i know how to test Outside SSIS.
July 25th, 2012 8:12am

Hi, I have tested in BIDS only . May i know how to test Outside SSIS. You can test the command itself in the dos command prompt. But if you tested in BIDS and it worked then the command itself it correct. So I guess you get this error when you run the package as a job. If so, I think it's a authorization problem: make sure your that the user (proxy/credentials) that runs the job has enough rights to execute the command and access these paths. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2012 8:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics