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

SSIS Package - Change connection property without opening package Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 8:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 7:55 AM
Points: 2,805, Visits: 3,067
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
Post #1494232
Posted Thursday, September 12, 2013 12:59 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
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.

Post #1494326
Posted Thursday, September 12, 2013 1:04 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1494327
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse