ConnectionString and ServerName

Question

ConnectionString and ServerName

solus

Hall of Fame

Points: 3495
More actions
December 8, 2009 at 9:59 am

#218614

Im modifying an SSIS package that uses several sqlserver databases and a few .mdb files (I import from these)
At the moment all the database connection strings and server names are hard coded. I want to avoid that to make it more portable. Whats the best way to go about this, are configuration files best or could I use variables ? Im pretty new to SSIS so any help would be greatly appreciated

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

I would use configuration files, they are fairly easy to setup and make moving packages from dev to prod a lot easier.

You can either assign the connection strings to variables and set these variables in the config file, or even easier would be to set the connection string directly in the config file.

There loads of example on Google/Bing to show you how it is done.

solus Hall of Fame Points: 3495 More actions · Answer 2

ok, thanks, ive taken a look at how to use them. How can the actual information inside the config file be edited though ?

Ive run through the config wizard and have built a config file for the current connections I have. Looking at the connectionstring for one sql server connection, I cant actually change its contents. Can this only be changed if I open the file up in notepad ? Thats not a great way to do this because its not formatted. I could probably do a search and replace, but it would be much nicer to be able to change it inside the configuration wizard itself