Hi all, I have an SSIS package to load a SharePoint list into an SQL Server 2008 table. I haven't used SSIS in a long time, since DTS days :) anyway I need to add a step to my import to only bring in new list items based off of Modified date. If it exists to update the table and if not add it to the table. I am using this table in an SSRS report where the users can insert misc sales into the SharePoint list and it will flow thru into my report. TIA, Joe

Hi Jay, Why NOT use Merge statement for this? http://technet.microsoft.com/en-us/library/bb510625.aspx http://technet.microsoft.com/en-us/library/cc879317.aspx Else look at this thread which is exactly what you want. http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/131dbe38-95a9-4b64-8434-60ba3cd6de00/--Sankar Reddy Blog: http://SankarReddy.com/ Twitter: http://twitter.com/SankarReddy13/

thank you I will let you know how it goes.

It seems you hesitate to use SSIS. I would recommend you to start using SSIS for this activity. :) This like will give you what you are expecting http://msdn.microsoft.com/en-us/library/dd365137(v=sql.100).aspx Thanks Ayyappan Thangaraj UG Lead, Puducherry http://SQLServerRider.blogspot.com

Thanks, I am trying to use SSIS :) My issue is that I can't get the proper syntax in a Data Flow task item to only bring in new items from the SharePoint list or update if something changes. I wanted to use Date modified to drive the logic whether to update or insert. Did I miss that in your post? I created the import, but I dont know how to set the conditions. thanks again, Joe