JOB failed to run SSIS package

Question

JOB failed to run SSIS package

Navigation

#1 by (1 votes)

1

I have created a JOB to execute an SSIS package but it gives me several errors.

If I execute the package manually, it does not fail but through the JOB if.

Next, you can see a screenshot with the errors.

Does anyone know what may be happening?

Thanks

ssis

asked by Fel 23.11.2016 в 10:31

source

1 answer

Pass a VARBINARY to INT as a listing in sql Laravel and Jquery: Help with error NotFoundHttpException in RouteCollection.php line 161:

score 1 · Accepted Answer

You could make sure of the following:

Is the user account you are using when you execute it manually the same as the one the agent runs?

Does the user account that runs the agent have sufficient permissions? (Access to the database for example)

If you are using SQL Server 2008 or higher on a 64-bit system, it may be troublesome not to have a 64-bit driver. In that case you could check the "Use 32-bit runtime" option in the "Execution options" tab within the corresponding Job step. (I do not have it installed in Spanish, but I'm sure you'll find out how it is in that environment)

I recommend a book, if you have not seen it yet. You have several FAQs about SQL Server SSIS that you may find useful.

link