You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Site Actions
This page location is:
SharePoint By Bugday
Comments
Synchronize SharePoint List with OLE DB
Edit Item
Browse
Tab 1 of 2.
Edit
Tab 2 of 2.
Sign In
Save
Cancel
Commit
Paste
Cut
Copy
Clipboard
Spelling
Spelling
SharePoint By Bugday
Comments
: Synchronize SharePoint List with OLE DB
Top Link Bar
SharePoint By Bugday
Currently selected
About Daniel
My Links
Old Blog Posts
SharePoint Forum
I work at
My Technet Ask The Expert Area
CodePlex
SP Technet Forums
SP2010 Conference Year 2011
Quick Launch
All Site Content
Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights.
More information on content approval.
Spelling...
*
indicates a required field
Title
Body
*
In the demo shown above, the package will create another (new) 18,484 rows in the SharePoint List every time it will run, as ID column is not matched. However, matching ID for Modification only works with SharePoint List Source & not OLE DB Source... Does anyone know of a way where I can sync my SharePoint List with SQL Server DB via scheduling a SSIS package, so that it doesn't create new records every time it package runs.
E-Mail
*
TodayIs
*
What's today's abbreviated value(DDD)
Attachments
Created at 12/16/2011 7:59 PM by
Last modified at 1/10/2012 2:43 PM by Daniel Bugday