February 8, 2011 at 10:01 am
I know this is simple if there weren't database parameters getting passed so here's what I want to do.
1) I have a dtsx package (let's call it pkgTest1.dtsx) that is getting excuted by VB code.
2) This VB code passes the server and database name to the dtsx package so whatever process task is in that package it only gets executed on that database.
3) At the end I want to execute another package (let's call it pkgTest2.dtsx) but this package also has a server and database name parameters that needs to be passed through so it only gets executed on that database.
So my problem/question is, is there a way to use the parameters getting passed from the VB code to be used to run pkgTest1.dtsx and use the same paramters to use for the pkgTest2.dtsx package?
February 8, 2011 at 2:12 pm
The answer is yes, you mostly can..
A brief overview:
1. Pass in the connection information to a package level variable not directly to the connection.
2. Using expressions adjust the connection to use the variable for the connection data.
3. Add a package level variable to the child package.
4. In the child package enable package configurations.
5. Add a package configuration, use the parent package variable option, specify the name of the variable from #1, this will pull the value from the parent INTO the child.
6. just like in #2 adjust the connection to use the variable created in #3.
This isn't step by step but it should get you most of the way there..
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply