Update the SQL table whne a new item is added in a sharepoint list

Oct 14, 2009 at 6:33 PM

Hi All,

 

        I have created a Integration Service Package with a SPList as the source and a SQL Table as the destination. I want the SQL Table to get updated when a new Item is added in to the SPList. I'm new to this.Can anyone please help me out.Thank you.

Coordinator
Oct 27, 2009 at 4:44 AM

With this component, you cannot update when a new item is added.  But you could schedule a job to run every X minutes and check for any new items since the last time, and update the new items as appropriate. If that might be a scenario you are looking for, then we can help you out.

Oct 27, 2009 at 5:14 AM

Hi kevinidzi,

 

                 Thanks for your reply. Well, that is what I'm looking for.