Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse