Using SSIS package not executing tasks in proper depandant sequence.
Posted on 2011-03-15
Using SSIS and in my ForEach Loop Container I have a two objects: 1st a Data flow task which is link to my SQL Task. The dataflow task is reading the data from 4 csv files from a network drive an writing those row into a SQL table. The problem is the four files are being processes in the for each loop completely before the stored proc is executed in the SQL Task even though their both in the Control Flow. I need my SQL task which is a stored proc to run after each file has been processed. I want the loop to complete each tasks in sequence before cycling throw to the next file. I have set up the data flow and the SQL task with the dependancies. I have set up the value property on the precedence Constaint to = "Success". Also, the execution results tab (display) is saying that it is executing 4 times successfully and independantly, howerver, it is actually not running at all. (the files on the network are not being moved). When I execute the stored proc in Managment Studio it runs perfectly.
I have no idea what else to do. Thanks for any help you can provide.