March 25, 2011 at 9:13 am
Hello,
I have a problem with the order of execution of tasks on my Control Flow.
My SSIS package extracts SQL data to 14 Excel files. To make sure the output files exist, I have Execute SQL tasks on the Control Flow to create the Excel files. I have these 14 tasks inside a Sequence Container. I have the Data Flow task that pulls the SQL data and sends it to the Excel files. I have a Precedence Constraint on the Control Flow from the sequence container to the data flow task.
When I run debug, the tasks in the Data Flow fail because the output files do not exist, as if the Data Flow tasks are running before the Execute SQL tasks on the Control Flow.
It all works great if I manually execute the Sequence Container and then execute the Data Flow. I need to figure out how to make the Sequence Container run before the Data Flow. Thanks for any ideas.
March 25, 2011 at 9:22 am
It sounds like a validation problem. There is a setting called DelayValidation at the package level (and others) that I am 99% sure is set to false. If you set that to true I think it will resolve your issue.
CEWII
March 25, 2011 at 9:23 am
Ken
I think there's a property of the package called Delay Validation. Try setting that to True. That way, SSIS will not try to check that the Excel files exist at the time the package is loaded.
John
March 25, 2011 at 9:29 am
Excellent. Thanks Elliott and John. I set DelayValidation to True for the package and that fixed my problem.
Thanks for the quick response!
March 25, 2011 at 9:38 am
You are very welcome.
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply