Post reply

SSIS package backup of sharepoint

  • December 2, 2013 at 5:06 am

    #283048

    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

  • December 4, 2013 at 2:25 am

    #1670633

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply