Hello, I have never worked with Share point DB's before, and I have to come up with a way to extract data from a share point DB using SSIS. Does anyone have any suggestions? Any help would be appreciatedDave SQL Developer

Hello, I have never worked with Share point DB's before, and I have to come up with a way to extract data from a share point DB using SSIS. Does anyone have any suggestions? Any help would be appreciated Dave SQL Developer There are three options: - Implement source script component and use SharePoint web service to pull data. - Use the third-party free component released by the SSIS team. - Use the third-party commercial CozyRoc SharePoint Source component, which is part of the SSIS+ library.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Thanks! Ok, which one of these options avoid installing any third party tools? It will take weeks for me to go through the proper channels to approve this... Dave SQL Developer

Thanks! Ok, which one of these options avoid installing any third party tools? It will take weeks for me to go through the proper channels to approve this... Dave SQL Developer Option number one. However it will take the longest amount of time to implement.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/