hi this is babu. I have one doubt on running ssis package. I have a dataflow task for inserting data from oledb source to oledb destination. i have to run this dataflow task when the source is updated(like inserting records and updating records). if there is no updations of source i dont want to run. what can i do... plz calrify my doubt

You have to implement logic of your own to find out if any update has happened on source. and then using precedence control you can set if you want to run the below data flow task or not. Logic can be anything that suits your system for example may be if TimeStamp > than last stored timestamp and then set a variable True or False and using it in Precedence controlRahul Kumar, MCTS, India, http://sqlserversolutions.blogspot.com/

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a205a4b5-e445-4df9-8a87-d761080e99b4/http://www.rad.pasfu.com

Hi, For data loading, in BI we need to get data on right time not real time. So I suggest you run the package at a fit interval like 5mins 10mins or others instead of loading data when source updated, because it will cause a lot of performance issue on source system. Isaac Li