SQL 2005

Feb 12, 2009 at 3:33 PM

I do believe this tool is what I need to complete a task I have on my plate.  However we are limited to using SQL 2005 as SQL 2008 is not yet approved for use in my clients organization.  I downloaded the SharePointListAdaptersSetupForSqlServer2005.msi and ran the install per the MSDN instructions.  I have SQL 2005 with the Business Intelligence Developer Studio 2005 however when I try to add the controls to the toolbox I do not see the SharePoint List Source and the SharePoint List Destination options in the SSIS Data Flow Items tab.  I even tried adding to the toolbax by adding the DLL from the Program Files... location and no dice.  What are the requirements for using the List Adapters for SQL 2005?  Do I need VS 2008 with some other component(s) installed? 

Feb 17, 2009 at 12:34 PM

I had the same issue and found an easy solution.  When you start the installation, change the destination folder from C:\Program Files\Microsoft SQL Server\100\DTS to C:\Program Files\Microsoft SQL Server\90\DTS.  Start BI Dev studio and you should now be able to add the tools.
Feb 17, 2009 at 3:02 PM
Oops! I'll update the path and put a new MSI up later today. Thanks for the catch!
Feb 17, 2009 at 3:12 PM
Feb 17, 2009 at 7:57 PM
Sure, you're welcome!
Feb 23, 2009 at 3:36 PM
I don't see the toolbar controls in the "Choose Toolbox Items"

and when I browse and select "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\SharePointListAdapters.dll"

I get:

"There was an error loading types from assembly "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\SharePointListAdapters.dll" Could not load file or assembly "Microsoft.SqlServer.PipelineHost, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91" or one of its dependencies.  The system cannot find the file specified."

I found version 9.0.3042.0 here:
C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

but couldn't find the version.

Feb 28, 2009 at 6:39 AM
Did you install the MSI for SQL2005?  It looks like you have the SQL2008 version of the components, when you are using SQL 2005.