Post reply

The connection "Servername" is not found. this error is thrown by connections collection when the specific connection element is not found.

  • March 3, 2011 at 8:32 am

    #147416

    Hi,

    I am getting below mentioned error while deploying the package from dev to test.

    Error: the connection is not found. this error is thrown by connections collection when the specific connection element is not found

    I am new to ssis, designed the package and checked, it is working fine. i am unable to deploy the package in testing.

    My ssis package contains dataflow task, which is having flat file as source connection and sql server as destination connection.

    The package is working fine in devlopment. Build the package with xml configuration. Changed the connection string values in test environment within the xml configuration.

    Please help me to overcome the above problem.

    Thanks in Advance,

    Naveen. N

  • March 3, 2011 at 12:25 pm

    #1294240

    Are you sure the connectionstrings from the configuration files are used? Check the logging (enable it if you have to) and see if there are any warnings or errors regarding the loading of the package configurations.

    Furthermore, make sure that the package has the necessary permissions to access everything you need on the test server.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply