/* */ SharePoint List Adapter in SSIS using GUID instead of name |SQL Works

Wednesday, October 2, 2013

SharePoint List Adapter in SSIS using GUID instead of name

So you have an SSIS package that pulls data from a SharePoint List, and it's working fine (It's not? start here), until...someone comes along and changes the name of the list, breaking your package and possibly failing the agent job that calls it...what to do?

You could just paste in the new name, but to fix this for good, you can use the GUID of the list to make sure that it does not happen again because the GUID remains constant even if the name changes.

In the properties of your SharePoint List source, in the name field, replace the text with the GUID of the list in question as shown below.



For anyone who doesn't have this installed yet, here is the link to the list adapter on codeplex

1 comment:

  1. One of the most amazing tool for getting SharePoint List data in to SQL Server. I'm using it with SharePoint 2010 and SQL 2012 and it has worked flawlessly it was extremely easy to set up and I've been able to automate so much data management.

    Thanks
    Silvester Norman

    Change MAC Address

    ReplyDelete