October 27, 2009 at 8:29 am
Hi Everyone,
I am trying to run one SSIS package which has a Data Flow Task. While running, SSIS shows the Data Flow task in "Yellow" (running status) color. How ever, control flow entries given inside the Data Flow task does not seem to be invoked (rather Not changed the color to Yellow).
I feel the control flow itmes are not invoked and SSIS shows the Data Flow task in yellow and does not even come to end for long time.
Any suggestions or clues why control flow items inside the Data Flow task is not being invoked?
Thanks to all in advance.
Suresh
Regards,
Suresh Arumugam
October 27, 2009 at 9:20 am
Do you have any lookups in your Dataflow?
SSIS has to cache all the data used for lookups before it can start the dataflow & if you are using very big tables for lookups this can take a very long time indeed....
If you can run the package from BIDS look at the "Progress" tab - this should show you what SSIS is working on prior to running the transform.
October 27, 2009 at 12:59 pm
Thanks for your time to reply for me. Below is the Progress status when i run the package in BIDS.
[font="Arial Black"]...
...
Progress: Validating - 100 percent complete
Validation is completed
...
...
Progress: Prepare for Execute - 100 percent complete
...
...
Progress:Pre-Execute - 0 percent complete
Progress:Pre-Execute - 12 percent complete
Progress:Pre-Execute - 25 percent complete[/font]
May I know why it is still in 25 percent complete? This task was running quickly yesterday. Also there are very less no. of rows in the corresponding tables.
Thanks
Regards,
Suresh Arumugam
October 28, 2009 at 1:17 am
If you are using lookup on particular table. Although it is small . Rebuild the index and then try. If you are using getting records in lookup using "Select" use nolock .
Hope this will help you
October 28, 2009 at 5:23 am
The only other possibility I can think of if the table is small is that the SSIS connection is being blocked by another process accessing the table??
Perhaps run SP_WHO2 & check the "blk by" column.
October 28, 2009 at 9:11 am
I found huge no. of records in the temp table which is processed in the Data Flow Task. After clearing the data in that, now the process runs fine and completes.
Thanks all for the reply.
Regards,
Suresh Arumugam
November 28, 2009 at 10:02 am
Check the isolation level of your package and your data flow. Serializable will lock the rows queried.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply