Making SSIS Connections Dynamic

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Making SSIS Connections Dynamic - SQL School...

Making SSIS Connections Dynamic - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Saturday, September 13, 2008 8:04 PM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Comments posted to this topic are about the item Making SSIS Connections Dynamic - SQL School Video

Brian Knight
Free SQL Server Training Webinars

Post #569123

Anipaul

Posted Thursday, September 25, 2008 3:24 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 4,787, Visits: 1,336

You are inspiring me to develop something .....

Post #575797

Sheldon Williams-262462

Posted Thursday, September 25, 2008 5:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 1:39 PM
Points: 2, Visits: 41

Brian,

Our development group currently uses this same method to dynamically assign connections as well. What I am curious about is that you stated it was better to assign the dynamic values to the database and server values rather than the connection string. Could you elaborate further? In our environment we have been assigning the dynamic value to the connection string and I am wondering if by doing that is that the source of the problems we seem to have when promoting SSIS packages to our production environment and the server names are different.

Post #575865

René Kapitein

Posted Saturday, September 27, 2008 2:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, September 27, 2008 1:57 AM
Points: 1, Visits: 0

Thanks for the presentation. I use variables in stead of a connectionstring myself for a while. The reason is that it makes it easy to switch between test and production server. I even added a small script as a first step to my package. When this step fails, I know I made a mistake in the server name.

Post #577276

« Prev Topic | Next Topic »

Permissions