Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS package backup of sharepoint Expand / Collapse
Author
Message
Posted Monday, December 2, 2013 5:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 2, 2013 10:56 AM
Points: 24, Visits: 134
Hi all,

Hi was assigned a project to make a backup of data from 3 lists in a sharepoint with the objective of using that data to do reports on it using Report Builder.

I was abble to do the downloads using the add in to do downloads Sharepoint List Source and Destination "plug in" in SSIS, now the issue is how to update the backup table only with updated and new rows, does anyone have some suggestions on this?

Best regards,

Daniel
Post #1518850
Posted Wednesday, December 4, 2013 2:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 29, 2014 2:57 AM
Points: 3, Visits: 38
Hi all,

i found a solution, it involves a plug in instalation for ssis to permit download of sharepoint lists, a staging table and a merge statement in the end, if anyone needs any details please let me know.

Regards
Post #1519529
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse