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

Making SSIS Connections Dynamic - SQL School Video Expand / Collapse
Author
Message
Posted Saturday, September 13, 2008 8:04 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Monday, August 19, 2013 12:07 PM
Points: 1,929, Visits: 228
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
Posted Thursday, September 25, 2008 3:24 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,191, Visits: 1,368
You are inspiring me to develop something .....


Post #575797
Posted Thursday, September 25, 2008 5:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 7:53 AM
Points: 2, Visits: 43
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
Posted Saturday, September 27, 2008 2:02 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse