none
Mster-chld

    Question

  • Hi,

    I have a master pkg calling child pkg in loop to load data in to target tables.  I have created the connection dynamically for child pkg task ( which is in for each loop) which is failing by error the systm cannot find the child pkg path.

    Steps I did in creating the dynmc connection

    1. Created a variable Connectionchildpkg_path (defaulted to child pkg path)

    2. created a xml pkg config file in master pkg, using pkg configuration

    3. For the variable  Connectionchildpkg_path I assigned the value as below

    <ConfigurationConfiguredType="Property"Path="\Package.Variables[User::Connectionchildpkg_path ].Properties[Value]"ValueType="String">
      <ConfiguredValue>C:\Users\Desktop\SSIS Packages\</ConfiguredValue>

    Note: <C:\Users\Desktop\SSIS Packages\> this is the path where I have all the child ssis pkgs

    4. Created a Connection Manager ChildCM and in expression property of ChildCM connectionstring I pointed to @Connectionchildpkg_path  variable, to pull the child pkg path.

    Ran the master pkg, I am getting the error saying child pkg not found at the "C:\Users\Desktop\SSIS Packages\" Path, but the child package is present at this location only.

    Is there any mistake i am doing in creating the dynamic connection for the child pkg?  the control is not passing to the child pkg at all.

    Thanks



    Neil


    • Edited by Neilcse Wednesday, July 23, 2014 1:21 PM
    Wednesday, July 23, 2014 12:10 PM

Answers

  • Nope the Connectionchildpkg_path value should be full package path along with package name

    Since you've a loop set up to iterate through child package you can do like this

    1. Have a variable inside loop (PackageName) to get child package name for each iteration

    2. set a new variable ChildpackageFullPath in parent and set value for using an expression as below

    @[User::Connectionchildpkg_path] + @[User::PackageName]

    3. Map the variable value to map to connectionstring of the package connection used inside the loop to pick the child packages dynamically

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by Neilcse Wednesday, July 23, 2014 1:20 PM
    Wednesday, July 23, 2014 12:21 PM

All replies

  • Nope the Connectionchildpkg_path value should be full package path along with package name

    Since you've a loop set up to iterate through child package you can do like this

    1. Have a variable inside loop (PackageName) to get child package name for each iteration

    2. set a new variable ChildpackageFullPath in parent and set value for using an expression as below

    @[User::Connectionchildpkg_path] + @[User::PackageName]

    3. Map the variable value to map to connectionstring of the package connection used inside the loop to pick the child packages dynamically

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by Neilcse Wednesday, July 23, 2014 1:20 PM
    Wednesday, July 23, 2014 12:21 PM
  • you got it right Visakh :)

    Neil

    Wednesday, July 23, 2014 1:20 PM