January 16, 2008 at 8:06 am
We have an SSIS package that pulls data from SQL tables, puts the results in txt files, triggers winzip to zip them up and then sends them to an FTP. When running the package in the designer in Visual Studio everything works fine. When running it from SQL Agent Job, command line or in SQL it hangs on the Winzip task. When I remove the wizip task it runs fine.
This package worked and I believe stopped working when we upgraded to SQL 2005 SP 2.
Anyone have a solution to this problem or a different approach to zipping up the files using SSIS?
January 16, 2008 at 9:17 am
What are the parameters you passed to unzip your text files
My Blog:
January 16, 2008 at 9:20 am
-min -m C:\FOLDER\File.zip C:\FOLDER\*.txt
January 16, 2008 at 9:36 am
Verify whether your sql server agent user has enough permission to C:\Folder
My Blog:
January 16, 2008 at 9:40 am
Yes. That is the first thing I thought of. I even went as far as temporarily setting the SQL Agent Service user Administrator rights.
January 16, 2008 at 9:49 am
http://www.mydatabasesupport.com/forums/sqlserver-server/189104-sql-agent-issue-winzip.html suggets you to do this with winzip command-line add-on
My Blog:
January 16, 2008 at 9:53 am
Yeah I saw that post. The curious thing is this thing has worked for almost a year and just stopped working either after installing SQL 2005 SP2 or an automatic update to Winzip. My fear is even with using the command line addon it will fail.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply