0

I have a SSIS project deployed in SQL Server SSIS 2015. I also have a scheduled job which runs the project in SQL Server 2016 (SQL Server Agent JOB).

When I run the project in the SQL Server Agent Job, I get this error (ADO NET Source has failed to Acquire the connection)

Error Message

But when I run the project in SSIS, it succeeds.

This is the connection manager that used in SSIS:

manager connection

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
dodo
  • 13
  • 1
  • 1
  • 7

0 Answers0