SSIS issue

• doung zhang

  SSC Rookie

  Points: 28

  More actions

  May 30, 2010 at 8:28 am

  #387044

  Hi There,

  This is the strange, and I need help. I have simple package truncate table then insert table, there is only two steps: oledb data source then oledb data destination (both sql servers).

  I have project setup at BIDS, inside data flow, two steps are showing green, but under control flow data flow task is still showing yellow, I check the table the data get inserted.

  Any idea what is wrong here, this is important since my next task is waiting for this showing green.

  I use Window 2003 enterprise edition 32 bit and SQL 2008 32 bit

  Thanks

  Don

• changbluesky

  SSC Eights!

  Points: 807

  More actions

  May 31, 2010 at 2:28 am

  #1174425

  No run into such a problem. Just one exception or all the data flow tasks encounter this issus?