Post reply

how to pass variable to child package in execute package task

  • December 16, 2008 at 4:42 am

    #155029

    Hi,

    im using a foreach loop to load many excel sheets in a file to database.

    to avoid complexity i split the package into two. so when i pass the filename variable to the child package it is not taking it.

    can anybody help me how to pass variable to child package.

    thanks in advance,

    karthik

  • December 16, 2008 at 7:36 am

    #913138

    Hi,

    Personally I believe that we can't paas variable into child package.

    Best thing you can do is that create two child packge having the variables and call these packages into parent package.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • December 16, 2008 at 8:29 am

    #913186

    You have to add a Parent Package Variable configuration to your child package.

    http://technet.microsoft.com/en-us/library/ms345179(SQL.90).aspx

  • December 17, 2008 at 7:22 am

    #913818

    You could also use two For..Loop containers. The outer to loop through each .xls file and the inner to loop through each sheet in a file. The difference with a usual setup is you need to use a .net connection to retrieve the sheet names.

    http://msdn2.microsoft.com/en-us/library/ms345182.aspx

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • December 17, 2008 at 10:09 pm

    #914289

    hi,

    that link was awesome..

    thanks everyone for helping me out..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply