VS2005 SSIS包没有看到自定义任务程序集-已添加到GAC [英] VS2005 SSIS package not seeing custom task assembly - that has been added to GAC

问题描述

1.我创建了一个自定义程序包，实际上，我创建了第二个程序包以确保第一个程序包没有问题.
2.使用gacutil添加到GAC中
3.使用Windows窗体作为测试应用程序测试装配.
4.打开VS2005和SSIS项目
5.单击常规"选项卡下的"ChooseItems"，然后在"SSIS控制流项目"下单击，它不会显示.

我正在生产盒上安装.当我在本地执行相同的过程时，只有在使用VS2008时，才在SSIS控制流项下的列表中看到自定义任务.我曾以为该组装件不在正确的位置，但是当我查看其他组装件的路径时，我发现所有这些组装件都在我放置自定义组装件并用于安装在gac中的路径中.即:c:\ program files \ Micrsoft SQL Server \ 90 \ DTS \ Tasks \

我不确定为什么可以成功使用Windows应用程序对其进行测试并且我也可以在本地框中创建SSIS程序包时，对话框没有显示我的新任务程序集.我唯一可以得出结论的是，在我的本地框上，程序集已编译.

有没有人有任何建议?

1. I have created a custom package, in fact, I created a second one to make sure that the first one did not have problems.
2. Added to the GAC using gacutil
3. Tested the assemblies using a windows form as a test app.
4. Opened up VS2005 and a SSIS project
5. Clicked on ChooseItems from under the general tab, and under SSIS Control Flow Items, it does not show.

I am installing on a production box. When I do this same process on my local, but only it is using VS2008, I see the custom task in the list under the SSIS Control Flow Items. I had thought that the assembly was not in the correct place, but when I look at the paths of the other assemblies, I see all of them are in the path were I placed my custom assembly and used to install in the gac. That is: c:\program files\Micrsoft SQL Server\90\DTS\Tasks\

I am not sure why the dialog box is not displaying my new task assembly when I can test it using a windows app successfully and I can also create SSIS package on my local box. The only thing I can come to the conclusion of is that on my local box, the assembly was compiled.

Does anyone have any suggestions?

推荐答案

摘要:

我的开发机器配置为:
1. VS 2005-如上所述，我在VS2005中开发了自定义程序集
2. VS 2008
3. VS 2010
4. SQL Server 2008
5. Windows 7操作系统

我要将新的自定义任务程序集部署到的机器是:
1. 2003年操作系统
2. VS 2005 SSIS

当我在此计算机上部署此新程序集时(即在gac中注册，复制到SQL Server目录的task文件夹中)，执行选择项目"时看不到该程序集.

分辨率:

将项目复制到具有以下配置的计算机上:
1. 2003 OS
2. VS 2005

我在这台计算机上打开了该项目，发现在引用下查找时，找不到所有Microsoft.SqlServer.Dts程序集.我重新分配了程序集并进行了编译.然后，我将此版本复制到要在其中部署的服务器，并且一切正常.这很奇怪，因为两台计算机上的版本是相同的.唯一的解决方案是对这些Microsoft.SqlServer.Dts的引用引用了较新版本的对象.

如有任何疑问，请告诉我.

Summary:

My development machine is configured as:
1. VS 2005 - as mentioned, I develop the custom assembly in VS2005
2. VS 2008
3. VS 2010
4. SQL Server 2008
5. Windows 7 OS

The machine that I am deploying my new custom task assembly to is:
1. 2003 OS
2. VS 2005 SSIS

When I deploy this new assembly on this machine (i.e. register in the gac, copy to the tasks folder of the SQL Server directory), I was not able to see the assembly when doing a "choose items".

Resolution:

Copied the project to a machine with the following configuration:
1. 2003 OS
2. VS 2005

I opened this project on this machine and found that all the Microsoft.SqlServer.Dts assemblies showed to be not found when looking under references. I reassigned the assemblies and compiled. I then copied this version the server in which I want to deploy, and everything worked. It is strange, because the version on both machines are the same. The only solution is that the references to these Microsoft.SqlServer.Dts referenced objects of a newer version.

If there are any questions, please let me know.

这篇关于VS2005 SSIS包没有看到自定义任务程序集-已添加到GAC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！