Error in SSIS script task to unzip zip file (64 but)

Question

Error in SSIS script task to unzip zip file (64 but)

pwalter83

SSChampion

Points: 14575
More actions
November 12, 2010 at 5:31 am

#149309

Hello Friends,
I am trying to run an SSIS package as a sql job. However, while trying to do so I am facing difficulty.
First of all the package was created in 32-bit machine and I am trying to install it to 64 bit.
When I do this, I get an error in one of the script task which unzips a zip file-
"Validation error. Unzip Zip file : The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated."
I have tried setting the Precompilescripttobinary to false and also the run64bit runtime as true but to no avail.
I also noticed that I am getting these line errors in the script task like Type 'java.util.zip.ZipInputStream' is not defined
'I have attached the code I am using in the script task. Any help would be deeply appreciated.
May Thanks,
Paul

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 1

Did the script work on the 32-bit machine it was created on? I suspect 32-bit incompatibility, but have you verified that the machine running the ssis package has java installed on it as well?

pwalter83 SSChampion Points: 14575 More actions · Answer 2

Hello,

Thanks for your reply. Ya the SSIS package which includes the script works perfectly on 32 bit. Also, the machine that I am running the package on has 64 bit java installed on it. Got any more ideas ??

Thanks again,

paul

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 3

Hmm, try forcing the package to run as 32-bit by calling the ssis package using the 32-bit dtexec, by default located at -

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\DTExecUI.exe

See if that works.

pwalter83 SSChampion Points: 14575 More actions · Answer 4

Hi,

Thanks again. I have already tried with the method you have advised but still get the same error. I have reached a point where virtually everything has been tried to rectify this but to no avail.

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 5

You mentioned you had the 64-bit version of java installed. Can you install the 32-bit version alongside the 64? My suspicion is if you are running a 32-bit package it won't be able to use the 64-bit version of java you have installed, resulting in the error.