May 1, 2015 at 7:24 am
Hi.
I have a master package that sets a date variable and then executes 4 child packages. Each of the child packages has a parameter binding to the date variable of the master package.
The first child package has a For Each Loop that loads data from any flat files in a set directory. When run standalone this works fine, but when run from the Master it gets the filename of the test file I am using but then does not import the data! No errors are reported. Also when you look at the progress report is shows that there are 12 rows in the file, but no rows get moved from source to destination.
This is the first time I have used a master package for a child package that uses a For Each file loop.
Has anyone any ideas where this is going wrong?
Thanks
Tim.
May 1, 2015 at 11:52 am
Try adding some script tasks/components to the child package that use MessageBox.Show() to tell you where you're at in the child package. YOu can also display useful stuff like the parent package variable(s) passed from the master to child.
Gerald Britton, Pluralsight courses
May 5, 2015 at 6:48 am
This is still happening, but is being caused by me leaving the project open on my PC overnight. If I save everything, close and re-open the solution then everything is fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply