UPdating Sharepoint list from ssis

  • hi can any one let me know some inputs on how to update share point list from ssis. i have searched many blogs and forums but could not find easy and good solution.

  • sri.gads (4/13/2011)


    hi can any one let me know some inputs on how to update share point list from ssis. i have searched many blogs and forums but could not find easy and good solution.

    Hi,

    There are solutions:

    1. Use the free SharePoint List Destination component. Available only for SQL 2008.

    2. Use the commercial CozyRoc SharePoint Destination component, with support for both SQL 2005 and 2008.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • I am using VS 2005, i would like to update the sharepoint list based on the update that is done in oracle.

    Can you please let me know any work around link or reference to do this.

    Thanks in Advance

  • sri.gads (4/14/2011)


    I am using VS 2005, i would like to update the sharepoint list based on the update that is done in oracle.

    Can you please let me know any work around link or reference to do this.

    Thanks in Advance

    I have already sent you links.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • Yeah, but this do not contain any work around sample. I would like to have work around or do a small sample for practice. i.e to update a sharepoint list from any source.

    i already have share point destination component installed.

    Thanks for you reply

  • sri.gads (4/14/2011)


    Yeah, but this do not contain any work around sample. I would like to have work around or do a small sample for practice. i.e to update a sharepoint list from any source.

    i already have share point destination component installed.

    Thanks for you reply

    You can download the source code for the free SharePoint List Destination component and review it. However keep in mind it is not trivial and involves alot of coding to do an update.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • sri.gads (4/14/2011)


    Yeah, but this do not contain any work around sample. I would like to have work around or do a small sample for practice. i.e to update a sharepoint list from any source.

    i already have share point destination component installed.

    Thanks for you reply

    A 'workaround' is something that you use to get round a problem that has no direct solution, but what do you mean by the term?


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

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