September 12, 2013 at 8:57 am
I am using SQL Server 2008 SSIS.
I used to have a DTS package using Dynamic property task so when I move from development to QA and to production, I don't need to open the package to change the database connection to different server and database.
But now I am using SSIS, everytime I change the SSIS package and when I move it to QA and production, I have to open it to change the database connection,
Is there a way to change the database connection without opening the package?
Thanks
September 12, 2013 at 12:59 pm
Yes, I use pkg configurations to define servername and databasename which I have dev values supplied for in the variables pane. On the server, I use Set Values tab to pass in local values - prod server and db name.
I think there are many ways to do configurations, but I've not used the xml or file type, just this easy little parent variable method since I really only need a couple values.
September 12, 2013 at 1:04 pm
Loner (9/12/2013)
I am using SQL Server 2008 SSIS.I used to have a DTS package using Dynamic property task so when I move from development to QA and to production, I don't need to open the package to change the database connection to different server and database.
But now I am using SSIS, everytime I change the SSIS package and when I move it to QA and production, I have to open it to change the database connection,
Is there a way to change the database connection without opening the package?
Thanks
This article will be really helpful.
Understanding Integration Services Package Configurations
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply