July 20, 2009 at 1:56 am
Hi,
I have SSIS package which has 5 tasks. Task in the my packages runs in this order task1-->task2-->task3--->task4--->task5.
Today when I ran the package it started to execute from 4'th task instead of 1'st task in package.
I thought that someone somehow must have changed the tasks precedence but, that was not the case. precedence was exactly same as it was before ie; task1-->task2-->task3--->task4--->task5. SSIS package tasks precedence changed automatically. can anyone throw light on this issue?
Thanks In Advance.
July 20, 2009 at 7:38 pm
Is it possible you've got one or more tasks disabled? They'll appear shaded in silver if they are.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
July 21, 2009 at 2:00 am
You can also check whether Checkpoint has been enabled. If checkpoint is enabled, if the previous taks execution has resulted in error in 4th task, then it would start from 4th when u re-run it
July 29, 2009 at 6:23 am
Nope all the tasks were in the enabled state, firstly that only I checked.
I am still facing this issue. whenever this issue raises I just remove all the arrows and replace those with new ones. miraculously this works. I don't want to do this every time. Please suggest something by which I can fix this permanently. I goggled but couldn't find anything about this.
July 29, 2009 at 6:24 am
even no checkpoints placed.
July 30, 2009 at 1:17 am
is anyone able to identify?
July 31, 2009 at 7:41 am
As sad as this is, you might just try creating a brand new package that does the exact same steps and replace the existing one with it. In my experience, sometimes it appears that the XML in the background gets messed up and the only way to correct the issue is to rebuild the package. This of course is not the best option because you still don't know what caused the issue, but if you're in a time crunch and have to get it done quickly this might work.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply