Hello - I have created a very simple data flow component for SSIS (Actually, I am following this example: http://www.microsoft.com/downloads/details.aspx?familyid=1C2A7DD2-3EC3-4641-9407-A5A337BEA7D3&displaylang=en). However, when I register the DLL to the GAC, I am unable to find the assembly in C:\Windows\Assembly - even though the GACUTIL says "Assembly Registered Successfully". Furthermore, after copying the DLL to the PipelineComponents folder for SSIS (C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents), it does not show in the "Choose Items . . ." dialog box of SSIS. I am running SQL Server 2008 Dev edition, Visual Studio 2010 with .NET 4.0, and Windows 7 Enterprise 64-bit edition. Any assistance/thoughts would be appreciated. Thanks!

How are you installing the DLL into the GAC? (You need administrator permissions to do this.) How are you looking for the DLL in the GAC? (The assembly is a special folder, and files don't necessarily appear there as you'd expect.) Lastly - simply Gacing and copying the DLL to the PipelineComponents folder isn't enough - you have to right-click on the toolbox and select "Choose Items..." to find it. Talk to me now on

Todd - To install the DLL, I am going to the VS2010 64-bit Command Prompt (in the Visual Studio Tools folder) and running the following command: gacutil /i "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelinComponents\SeeBuffer.dll". I also tried this using the 32-bit command prompt with no success. In the past, when I have installed a DLL to the GAC, I can verify its sucess by looking in the C:\Windows\Assembly directory. Although the aforementioned command resolves to "Success", I cannot see it in the C:\Windows\Assembly directory. My apologies if I was not clear on this before, but when I go to "Choose Items . . ." in the toolbox, my custom component does not show. I am a local admin on this machine. Thanks.

OK - thanks for the info. Can you post the output of the GACUtil command? Talk to me now on

Sure: C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents>gacutil /i "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents\SeeBuffer.dll" Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.1 Copyright (c) Microsoft Corporation. All rights reserved. Assembly successfully added to the cache C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents>

Interesting. It certainly looks like you should be able to see that in the GAC (C:\Windows\Assembly). To be perfectly clear - I'm assuming you're "looking" at the GAC by navigating there using Windows Explorer. If you're using the command line, it's a LOT less simple. Second - just to check - the items shown to you in the GAC are NOT shown by the name of the DLL. They're shown by the name of the assembly, which can definitely be different. That's in the project properties of your project - so maybe you need to look for that. This may also explain why you can't find it when you Choose Items to the toolbox... Talk to me now on

For the GAC issue I would have expected an error through if permissions was the issue, but I cannot thing of anything else. Could you double check the Administrator point. I'm an admin on my machine but with UAC it still means I need explicitly start an application as an Administrator. e.g. Right-click "Visual Studio Command Prompt" in teh start menu and select Run as Administrator. For point about it not showing up in Choose Items for the Toolbox, restart the SQL Server Integration Services service on the local machine as that caches component information, so you need to force it to refresh. http://www.sqlis.com | http://www.konesans.com

@Todd - That's correct; I am navigating to the C:\Windows\Assembly folder via Windows Explorer. Also, I double checked the assembly name in the Project Properties panel of my project (Application tab) and saw that the assembly name is identical to the DLL name. @Darren - I just tried it that way (running the command prompt as 'Run as Admin') with no success. I also restarted my PC, but still no success in finding the component in the toolbox. Thinking about this differently, is there a command (or method) other than GACUTIL in the command prompt that will show the steps that are taken to register a DLL to the GAC? Or is there another means to do this that will output a log file so I can verify the changes took (like a receipt)?Try not, do or do not, there is no try. -Yoda

The methods I know of for adding assemblies to the GAC GACUTIL - It shoudl give an error message when goes wrong... so no idea what is wrong with this one Drag and Drop the file into C:\Windows\Assembly Installer MSI (WIX) - A bit much for now, as the others should work just fine When you view C:\Windows\Assembly, it does look different to a normal folder? It should have column headings like Assembly Name, Version, Public Key Token. You should have the SSIS assemblies in there already, such as Microsoft.SqlServer.Dts.Design, Microsoft.SqlServer.DTSRuntimeWrap, and Microsoft.SqlServer.ManagedDTS? Have you compiled your assembly for any specific processor? The Any option should do just fine.http://www.sqlis.com | http://www.konesans.com

You might want to try the "/f" option to try to "force" the DLL to be (re)installed... but other than that, I can't see why it's not working for you. It reports success... You've obviously strongly named and signed the assembly, otherwise it would complain about that. GACUtil is verbose by default, so it's reporting as much information as you're going to get... Talk to me now on

@Darren - I am using the Any option to compile. Should I change this? @Todd - GACUTIL did not take the /f option, but it did take the /if (/i + /f) option. This, however, still did not work.Try not, do or do not, there is no try -Yoda

Do you have access to any .Net developers locally? Someone who could get hands-on with your system? They could likely track down your issue faster than our Q&A - because I think we've hit the wall here. GACUtil should "just work" or report an error. If it claims it's installing your assembly, then it is... What happens if you attempt to uninstall your assembly from your GAC? Can you show us the output of that GACUtil command? Talk to me now on

Hi, I was struggling with exactly the same problem yesterday.. created a component in VS 2010 (.NET 4.0), registered the component using GACUtil with no error, but not being able to find the component in the cache directory nor in the SSIS toolbox... I spend several hour trying to find out whats going on. Then I tried to run the GACUtil from a dos batch file - and an error appeared saying that I am trying to register assebly .NET 4.0 on a computer that runs 3.5.. Then changed the target framework in VS 2010 to 3.5, rebuild the project and voila- the component finally appeared in the toolbox list... this is the batch i used to register assembly: REM Unregister and re-register the assembly on the GAC "C:\Program Files\Microsoft SDKs\Windows\v7.1\Bin\gacutil" /u ChangeCase "C:\Program Files\Microsoft SDKs\Windows\v7.1\Bin\gacutil" /i "C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\ChangeCase.dll" pause this batch will show the list of assemblies in the GAC: "C:\Program Files\Microsoft SDKs\Windows\v7.1\Bin\gacutil" /l > gacListing.txt hope this helps... Frank

That was it! THANK YOU FRANK!!!! Interesting though considering I am using Visual Studio 2010 (which includes the .NET Framework 4.0) on a Windows 7 Enterprise machine. In my spare time, I theorize on that - but I'm just glad it registered. Thanks again! Oliver

Thanks a lot Frank....It is working...:-)