Source (SQL Server) connection error

  • 16Views
  • Last Post 3 weeks ago
Libby Schmit posted this 3 weeks ago


I already set up the source connection from a SQL server and when I click the test connection botton, I get a notification that the connection is successful. The problem that I'm having is that when I'm trying to add a new task in my package, I can't, because I'm getting an error that tells me to select a valid Source connection. I don't know why I'm getting this becuase the connection is successful. 

Attached Files

Yevheniia Bilotserkovska posted this 3 weeks ago

Hello Libby.

Thank you for contacting us.

Currently your Security Agent 'Alliance Prod Agent' is not connected.

Could you please relaunch the Agent, save this connection, and then refresh the connection in your Package and let us know whether it helps.

If you encounter any issues please let us know.

Best regards,

Yevheniia Bilotserkovska.