SSIS package runs fine until put in a job

I see this issue pop up every now and then: A developer creates an SSIS package in BIDS and gets it to run fine.  Then the developer connects to Integration Services and uploads the package to the server, and then uses the Run Package, and again it runs fine.  But once the developer creates a job that runs the package, the job fails, despite all the correct security settings.

It’s a bit confusing: when you use the “Run Package” command in SSMS when connected to Integration Services, it starts the Execute Package utility (dtexecui.exe), which always runs a package on the local computer, even if the package is saved on a remote server.

So, if the package is using a local resource that is not there by default, like an Oracle ODBC driver, you must install that driver on the server that the package is on in order to get things working.

More info:

Stupid me #2 – Where is my SSIS package executed?

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQLServerPedia Syndication, SSIS. Bookmark the permalink.

One Response to SSIS package runs fine until put in a job

  1. Pingback: SQL Server “Denali”: Details on the next version of SSIS | James Serra's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>