SSIS添加一个存在的包实际上添加了一个相同的副本 [英] SSIS adding an existed package actually added an identical copy

问题描述

我尝试使用Visual Studio将现有包添加到SSIS项目中.但是事实证明，该工具将程序包复制到新程序包中，并将其命名为原始名称，再加上一个递增的数字，然后将该程序包附加到项目中.我知道我错过了一些设置.但是我找不到导致原包装无法附着的原因.任何人都遇到相同的问题.谢谢！

I try to add an existed package to a SSIS project using Visual Studio. But it turns out the tool copies the package to a new package and name it as original name plus an incremented number first and then attach the package to the project. I know I miss some settings. But I could not find out what prevents the original package from attached. Anyone encountered the same problem. Thanks!

推荐答案

在这里发生的情况很可能是您已将包手动复制到项目目录中，然后尝试将其添加到现有项目中. BIDS(Visual Studio)假定您要从其他位置复制，使用名称并将项目复制到您的目录中，找到现有副本，然后重命名新副本以防止名称冲突.

What is happening here is most likely that you have copied a package manually into the project directory and then tried to add it to the existing project. BIDS (Visual Studio) assumes you are copying from a different location, takes the name and copies the project into your directory, finds an existing copy, and renames the new one to prevent name collision.

解决方法#1 :添加现有对象之前，请将其移动到项目空间之外的临时目录中.选择添加现有程序包，然后复制到您的项目中.程序包将具有正确的名称.

Workaround #1 Before adding an existing object, move it to a temp directory outside of your project space. Choose Add Existing package and copy into your project. Package will have correct name.

解决方法#2 在原始方案之后，从磁盘上删除原始文件，然后从BIDS(Visual Studio)中重命名副本.这会将您的包裹重命名为正确的名称.

Workaround #2 After original scenario, delete the original from disk, then rename the copy from within BIDS (Visual Studio). This will rename your package to the correct name.

这篇关于SSIS添加一个存在的包实际上添加了一个相同的副本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！