I've upgraded my sql server and moved all the Databases and agent jobs to a new server from 2012 to 2016 and exported and imported the SSIS packages.

I have maintenance job which run a SSIS package the job always fails with this error

enter image description here

  • 1
    Have you checked the credentials for the sa account? – scsimon Oct 14 at 15:37
  • No is that in the SSIS package ? – SKhawaja Oct 14 at 16:56
  • In the SSIS package you have connection managers which setup connections for use in the SSIS tasks. Based on this error message, ie 'login failed for user 'sa'', it would seem that you have a connection manager in this package using sa as a login and that may have incorrect credentials. – kevinnwhat Oct 14 at 18:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.