Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1211
  • Last Modified:

SSIS package failing on zip script task when run by SQL Server Agent job

Hi,

I have a SSIS package that was deployed successfully on a SQL Server cluster (2-node, active/passive config). This package was deployed to run as a scheduled SQL Server Agent job on the active node and it has run fine for several weeks. Recently, a configuration change was made that flipped the cluster configuration and this broke the job.

The package features a C# script task that handles an unzip task. This utilises the Microsoft J# redistributable and I used the code from one of the public SQL blog sites. When I run the package interactively in BIDS on the new active node, it runs fine. However, when I run the SQL Server Agent job, it fails with the following error message:
"...System.IO.FileNotFoundException: Could not load file or assembly 'vjslib, Version=2.0.0.0, Culture=neutral..."

I am guessing this is something to do with the SQL Server Agent proxy account but I'm not sure how to fix it. The proxy account in question is linked to a credential based on a domain account that has admin permissions on both servers in the cluster. When I ran the package successfully in BIDS on the active node server, I was logged in (to Windows) with this domain account (the SQL database connections in the package use the SQL sa account). I tried running the J# redistributable installer again and ran a repair, but this has made no difference.

Can anyone assist me please?

Thanks in advance.
0
irb56
Asked:
irb56
1 Solution
 
irb56Author Commented:
I tried uninstalling Microsoft Visual J# Restributable Package, then reinstalling whilst logged on as the domain user that is also used as the credential/proxy account for running the SQL Server agent job. This made no difference. I tried deleting the script task that does the zip work and recreating it in the package, then re-deploying the package. This made no difference.

Finally, I changed the execution options of the SQL Server Agent job step to use the 32 bit runtime and this fixed the issue!

Unfortunately I now have another problem with the package, for which I will raise a new question!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now