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