Post reply

Impact on Sharepoint databases if updating from SSIS

  • October 9, 2015 at 6:48 pm

    #301342

    Hello

    I would like to know your views regarding updating Sharepoint data in lists/libraries using SSIS on a "regular" basis, like scheduled jobs every night.

    Would Sharepoint databases be corrupted? Would it have an impact on performance?

    Thank you all in advance

  • October 10, 2015 at 4:41 pm

    #1832691

    fiyo (10/9/2015)

    Hello

    I would like to know your views regarding updating Sharepoint data in lists/libraries using SSIS on a "regular" basis, like scheduled jobs every night.

    Would Sharepoint databases be corrupted? Would it have an impact on performance?

    Thank you all in advance

    Hello anyone??

  • October 11, 2015 at 8:18 pm

    #1832730

    SharePoint has a number of web services that allow you to update lists. If your SSIS package is using one of these there is no risk of corruption.

    If you are directly update tables in a SharePoint database - you will not get any support from Microsoft if something goes wrong. This is not supported and you are taking on the risk of corruption if you get it wrong.

  • October 11, 2015 at 11:51 pm

    #1832735

    Would have to agree with HappyCat59 with regard to directly trying to do this, however you may wish to check out the following:

    http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652.

    Which links from:

    https://msdn.microsoft.com/en-us/library/hh368261.aspx

    Hope this helps

    ...

  • October 12, 2015 at 3:51 am

    #1832766

    thank you very much happycat59 for the advice and happygeek for the links. Will check these out

    regards

Viewing 5 posts - 1 through 4 (of 4 total)

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