Data load from sharepoint
How do we pull data from files located on a sharepoint location..
January 25th, 2012 12:54pm

Hi, you have the SharePoint List Source and Destination components. Is this what you want? http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 David.
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2012 1:10pm

Thanks for the quick reply...These are external components that need to be dowloaded right....how do they work..will they add these compnenets to the control flow list..? Is there any other way to do it....like mapping a network drive and use the sharepoint path?
January 25th, 2012 2:11pm

Yes, you need to download them and add to your toolbox. Check the Readme file to see the instructions: http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652#DownloadId=44462 Yes, you can also map a network path to a document library and access it like a network path: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010setup/thread/9d66ed88-c970-476a-8c34-719d4323edf2 David.
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2012 2:17pm

Hi, you have the SharePoint List Source and Destination components. Is this what you want? http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 David.
January 25th, 2012 9:04pm

Another option are the commercial CozyRoc SharePoint Source and SharePoint Destination components. They are part of CozyRoc SSIS+ library.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2012 9:04pm

Yes, you need to download them and add to your toolbox. Check the Readme file to see the instructions: http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652#DownloadId=44462 Yes, you can also map a network path to a document library and access it like a network path: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010setup/thread/9d66ed88-c970-476a-8c34-719d4323edf2 David.
January 25th, 2012 10:11pm

Another option are the commercial CozyRoc SharePoint Source and SharePoint Destination components. They are part of CozyRoc SSIS+ library.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2012 4:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics