Custom component not in BIDS Toolbox (but in GAC)
Hi, I've created a custom component in VS 2010 (.NET 3.5). I successfully added the resulting assembly to the GAC and I'm able to see the assembly in the browser (C:\Windows\assembly). But unfortunately I'm not able to add the component to the BIDS Toolbox. When I open BIDS-Toolbox-Choose Items-SSIS Data Flow Items I do not see the component. Any suggestions on what I may do wrong? Regards
May 25th, 2011 8:59am

Did you restart Visual Studio? It caches the GAC on startup. See also this post: http://consultingblogs.emc.com/jamiethomson/archive/2006/02/08/SSIS_3A00_-Deploying-custom-tasks-and-component.aspx Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 9:07am

Yes - I already did that without success. I also rebootet my system but it's still not there...
May 25th, 2011 9:35am

And have you copied the dll to c:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents or to your framework 3.5 folder? Not sure about the exact location, but I thought that's where VS searches for the dll's.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 10:02am

Not "or" - the assembly has to be placed in %Program Files%\Microsoft SQL Server\90\DTS\PipelineComponents or %Program Files%\Microsoft SQL Server\100\DTS\PipelineComponents (depending on SQL version). If you're running 64-bit, it needs to also be in %Program Files%\Microsoft SQL Server (x86)\90\DTS\PipelineComponents or %Program Files%\Microsoft SQL Server (x86)\100\DTS\PipelineComponents. Talk to me now on
May 25th, 2011 12:33pm

OK. I'll try that. Does it have to be in the GAC additionaly?
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 6:16am

Unfortunately it still doesn't work. I copied it to the %Program Files%\Microsoft SQL Server (x86)\100\DTS\PipelineComponents folder. This is the folder that is used in BIDS (I can see that in the Choose Toolbox Items - Data Flow Items section). I restartet VS and also rebootet the system, but it still is not there... Additionaly I'm not sure about the fact why I have to publish it to the GAC and additionaly copy it to this folder? Is the GAC only used on runtime and the folder during the design?
May 26th, 2011 8:13am

See this document for more details: http://msdn.microsoft.com/en-us/library/ms403356.aspx Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 8:41am

See this document for more details: Building, Deploying, and Debugging Custom Objects http://msdn.microsoft.com/en-us/library/ms403356.aspx Let us know if it worked for you... Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
May 26th, 2011 8:41am

Your use of the "(x86)" part in the path wasn't where I expect it to be. Looks like you're on a 64-bit SQL 2008 system, yes? If so, make sure the DLL is in the GAC (yes, it needs to be there for runtime) as well as in BOTH the 64-bit and 32-bit Program Files folders "PipelineComponents" subfolder. All three places. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 4:57pm

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

Other recent topics Other recent topics