部署的 SSIS 包未反映对包所做的更改 [英] Deployed SSIS Package not reflecting changes made to package

问题描述

我在 MS Visual Studio 2019 (MS VS 2019) 中对我的 SSIS 包进行了更改.当我将更改后的包部署到集成服务目录并重新运行作业时，更改似乎没有得到反映.我所做的更改是添加一个截断并重新加载到临时表.我知道它不起作用，因为在作业运行后，临时表没有任何记录.当我从 MS VS 2019 中手动运行项目时，它可以工作(即填充了临时表).

I have made changes to my SSIS package within MS Visual Studio 2019 (MS VS 2019). When I deploy my changed package to the Integration Services Catalog and re-run the job the changes don't appear to have been reflected. The change I made was to add a truncate and re-load to a staging table. I know it's not working because after the job has run the staging table does not have any records. When I manually run the project from within MS VS 2019 it works (i.e. the staging table is populated).

我尝试从 MS VS 2019 部署项目，仅从 MS VS 2019 部署包，以及将包文件从本地计算机上的位置复制到 SSIS 访问的 MS SQL Server 计算机上的目录目录.这些似乎都不起作用.

I've tried deploying the project from MS VS 2019, deploying just the package from MS VS 2019 as well as copying the package file from its location on my local machine to the directory on the MS SQL Server machine accessed by the SSIS catalog. None of these seem to work.

推荐答案

我已经遇到过这个问题.您是在项目级别部署 .ispac 还是在包级别?在这两种情况下，我怀疑您的项目构建存在错误.在您的解决方案目录中，尝试删除位于 bin/文件夹中的 .ispac.您还可以删除 obj/文件夹的内容(为安全起见，请将其移动到另一个文件夹中，以防您必须恢复它).然后在 Visual Studio 中重建您的解决方案..ispac/.dtsx 文件应该更新为准备部署.

I already met this issue. Are you deploying at project level with a .ispac or at package level ? In both case, I suspect a bug with the build of your project. In your solution directory, try to delete the .ispac located in the bin/ folder. You can also delete the content of the obj/ folder ( to be safe, move it in another folder in case you have to restore it). Then rebuild your solution in Visual Studio. The .ispac/.dtsx files should be updated a'd ready to deploy.

希望能帮到你.:-)

I hope it helps. :-)

这篇关于部署的 SSIS 包未反映对包所做的更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！