The following forum(s) have migrated to Microsoft Q&A: All English SQL Server forums!
Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

SSIS import logic

Question
0

Sign in to vote
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
- Moved by Tom Phillips Monday, May 16, 2011 1:44 PM SSIS question (From:SQL Server Database Engine)
Friday, May 13, 2011 5:48 PM

All replies

0

Sign in to vote

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/

Friday, May 13, 2011 7:02 PM
0

Sign in to vote

thank you I will let you know how it goes.

Friday, May 13, 2011 7:36 PM
1

Sign in to vote

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

Saturday, May 14, 2011 7:32 AM
0

Sign in to vote

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

Tuesday, May 17, 2011 7:08 PM
0

Sign in to vote

Hi Joe,

Here is a step-by-step of some various options using a SharePoint list as a data source.

http://dataqueen.unlimitedviz.com/2011/06/how-to-use-a-sharepoint-list-as-a-data-source-in-your-ssis-package/
Martina White

Tuesday, September 17, 2013 6:54 PM