We help IT Professionals succeed at work.

Set up source connection as a parameter in SSIS packages

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

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