I'm building a lot of SSIS packages and I'd like to use a SharePoint Data Connection Library to store the connection.ds file and have each package retrieve it from there.Can it be done?Peter

>I'm building a lot of SSIS packagesSSIS ?By the look of it this is an SSIS question rather than a SharePoint one.Try asking in this forum http://social.technet.microsoft.com/Forums/en-US/whatforum/threads/ where you should postSSIS questions to.

It's really a SharePoint question. A lot of MS products use data connections and I'd like to store them all in just one place. SharePoint seems to be the place to put them but it seems that Excel is the only app that can see them. That's why I put the question here.Peter

Hi, Kevin Idzi recently filled this need by releasing the SharePoint List Source and Destination components on the Microsoft SQL Server Community Samples: Integration Services site on Codeplex. Recently Kevin wrote up an article with screen shots that explains the features and properties of the SharePoint List source and destination, and walks you through setting them up. You'll find that article here: Extracting and Loading SharePoint Data in SQL Server Integration Services Hope it can help you.Xue-Mei Chang

Thank you for the response. This looks good but complicated. Is there any way to point the SSIS data connection directly to the folder/file where SharePoint puts it? I don't know if SharePoint even stores it that way.Peter

If you can use third-party solutions, check the commercial CozyRoc SharePoint integration. These are the relevant components: SharePoint Source SSIS Data Flow Component SharePoint Destination SSIS Data Flow Component SharePoint SSIS Connection Manager Batch insert and update is also supported. Cheers!SSIS Tasks Components Scripts Services | http://www.cozyroc.com/