Initial Catalog value Ignored in SSIS VS 2010

  • I'm having an issue where old SSIS packages that I've taken over once worked connecting to all servers. Now that I've made a few updates (not connection strings), when connecting to SQL Server 2012 or 2005, I connect fine, but the Initial Catalog value is ignored forcing the connection to the default DB. Here is my connection string, which does not have the same issue as the post before, but is still having the Initial Catalog value ignored.

    Data Source=DevSQL01;Inital Catalog=dbStage;Integrated Security=SSPI;Auto Translate=False;Application Name=MRM;

    The issue surfaced where an older developed SSIS package updated to VS 2010 seems to have worked until my last update. The server running the SSIS package is SQL Server 2012 connecting to a 2012 or 2005 database.

    Any help would be appreciated.

  • Any package configurations? (if using package deployment model)

    Or parameters used to configure connection strings?

    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