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