January 30, 2009 at 2:35 am
I have created a package(Test) and in that 1 source & 1 destination (both are in same database on dev environment). My requirement is I want to point these source and target to a QA environment. This I need to do outside of the package ie runtime.
January 30, 2009 at 7:17 am
You can set the SOURCE & TARGET connections (by setting "ConnectionString" property) dynamically using Expressions...
Look for Package Configurations, Expressions in BOOKS ONLINE
--Ramesh
February 2, 2009 at 12:45 am
Hi,
I tried working with Variable & Configuration files. But not Luck. Canu please be more specific by sying how to do if u have already done this earlier.
Thanks
medisetti
February 2, 2009 at 1:42 am
You have follow these steps.
1. Create 2 String varibles "SourceConnectionString" & "TargetConnectionString"
2. Create 2 Connections, 1 for Source & the other for Target
3. In Source Connection Properties, go to Expressions and set the "ConnectionString" property to the variable "SourceConnectionString", Similarly do the same for Target Connection w.r.t variable "TargetConnectionString".
4. Create a New Package Configuration using a wizard and in the variable selection windows, select both the variables and their "Value" propery.
5. An XML file created with these configurations, which the package uses for assignment before the execution.
--Ramesh
February 2, 2009 at 2:12 am
Pavan,
You can try these links:
http://www.programmersedge.com/?p=56
http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm
Never forget to set ConnectionString property of your Connection Manager with package variables.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply