December 15, 2011 at 2:25 pm
I have a problem populating a connection string properly. Let me start at the beginning.
1. I have a dtsConfig file containing the variable, ConnectionString_parent.
2. Parent reads the ConnectionString_parent variable from the dtsConfig and uses the value for the connection string of an OLE DB connection.
3. The parent package calls the child package.
4. The child package has a parent package variable that "connects" the ConnectionString_parent to the ConnectionString_child variable.
5. The child package is SUPPOSED to take the value of ConnectionString_child and use it as the connection string for its own OLE DB connection.
Unfortunately, all the steps occur properly except for step 5.
Also, the parent and child packages are all deployed to SQL Server. I am running the parent package from the SSIS package store.
Can anyone help me with this? I've been beating my head against the wall for a couple of hours now.
December 16, 2011 at 12:23 am
How did you configure the child package connection manager? With an expression?
Are you sure you deployed the last version to the server?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 16, 2011 at 8:39 am
Well darn Koen, you didn't leave me anything else to ask..
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply