Database Reference
In-Depth Information
Figure A-5 . Assigning the User::ChildPackagePath variable to the ConnectionString expression
Click the OK button to close the Expression Builder and then click the OK button
to close the Property Expressions Editor. At this point, the ConnectionString
property of the Child.dtsx file connection manager is managed by the
User::ChildPackagePath SSIS variable. You can test this functionality by cre-
ating a second test child package. Fortunately, creating a second test child package is
relatively simple.
In Solution Explorer, right-click the Child1.dtsx SSIS package and then click
Copy. Right-click the SSIS Packages virtual folder and click Paste. Change the name of
the new package from Child1 1.dtsx to Child2.dtsx .
 
Search WWH ::




Custom Search