Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Initial Catalog value Ignored in SSIS VS 2010 Expand / Collapse
Posted Tuesday, October 29, 2013 9:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 8:39 AM
Points: 6, Visits: 33
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.
Post #1509646
Posted Wednesday, October 30, 2013 2:19 AM



Group: General Forum Members
Last Login: Yesterday @ 1:35 AM
Points: 15,510, Visits: 13,170
Any package configurations? (if using package deployment model)
Or parameters used to configure connection strings?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1509678
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse