Initial Catalog value Ignored in SSIS VS 2010

• Bradley McGuffey

  SSC Veteran

  Points: 214

  More actions

  October 29, 2013 at 9:51 pm

  #395742

  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.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  October 30, 2013 at 2:19 am

  #1662630

  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