Post reply

Running a SSIS Package inside another

  • May 1, 2008 at 3:23 am

    #187204

    Hi All,

    The problem I am having is I have 5 individual SSIS packages that load data from a file source. The packages load the data into their respective tables, and at the end it gets a record count from the file and a record count from the table and inserts the record count into a Log Table.

    This works fine when running each package seperately in BIDS, but when running the package from SQL Server Manager or in BIDS (running each package from within another package) the table record count gets inserted, but the file record count does not.

    Can anyone help?

  • October 28, 2009 at 1:28 am

    #1071567

    Check scope of variable which are storing counts for file data source. It should be at package level. I also had gone through same situation. I changed scope of variable and it started working.

Viewing 2 posts - 1 through 1 (of 1 total)

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