BIDS not loading data - SSIS

  • Hi Friends,

    i am just trying to load 100,000 recrods into a table. But i have a weird situation where my data is not loading. data flow starts to load but then i don't know what is going on..it seems like got stuck....i waited for more than 30 minutes but it is not loading the data. i even checked for the table lock against the respective database but got nothing. Please help me, friedns. I have attached a screen shot.

  • have you looked on the progress tab for the 'red and white bubbles' that show errors? When things get stuck like that, and do not turn red, there are often sneaky errors posted that you would not otherwise find.

  • herladygeekedness (6/12/2013)


    have you looked on the progress tab for the 'red and white bubbles' that show errors? When things get stuck like that, and do not turn red, there are often sneaky errors posted that you would not otherwise find.

    No...I checked but i don't get any error over there...i have attached a screen shotfor your reference....

    could you please suggest me what else i have to verify? this thing sucks me more...

  • It looks like an error occurred simply because I see an On Error task firing.

    take a look at the Event Handler tab to see what might be lurking under On Error. Maybe that piece is flawed?

    I don't make a lot of use of Event Handlers aside from rudimentary logging but maybe if you remove the On Error event handler you will be able to let it break and see what the error really is?

    Do check for nulls in your data flow in case it's something like integrity constraint violation as it does appear that No records were written.

    Agree, SSIS can be extremely frustrating.

  • It could be because of buffer size issue. Trying loading only 20000 rows at a time and repeat this step for five times using for loop container.

  • It was one of the event handler....it caused the problem....it is now fixed.... Thank you Herald....

    you made me to remember that i am using event handler....:-)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply