Solved

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

Posted on 2011-02-24
1
1,174 Views
Last Modified: 2012-05-11
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
Comment
Question by:irb56
1 Comment
 

Accepted Solution

by:
irb56 earned 0 total points
ID: 35005878
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now