Set up source connection as a parameter in SSIS packages

T Hoecherl
T Hoecherl used Ask the Experts™
on
Is it possible to create an SSIS package in Visual Studio with the Server Name and Data Source in the Source object as a parameter, so that you can provide the SQL server name at runtime?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
You could use a configuration file for the SSIS package like described here:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66500/
Sr. BI  Developer
Commented:
Hi, Yes sure, that's the main reason variable and parameters are being used for when you move the package from DEV to QA or to PROD, the server name and credentials are usually different.

I'd assume that you're using SQL 2012 + since you mentioned the word "parameter"  

please check that post:

https://www.sqlshack.com/parameterizing-database-connection-sql-server-integration-services/
T HoecherlDeveloper

Author

Commented:
Thank you very much for your help.

T

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial