如何在两台不同的机器上使用相同的SSIS包？ [英] How can same SSIS package have different size on two different machines?

问题描述

我有一个SSIS包。它被用在两台不同的机器上，用于不同的数据库。

问题是，在其中一台机器上，SSIS包的大小显示为83 KB，另一台则为323 KB。差异很小大小是可以理解的..但是这样的区别不是。

任何想法是什么原因？



提前致谢。



我的尝试：



我拿了两个包（来自不同的机器）和逐个比较他们的任务。一切都一样。

I have a SSIS package. It is being used on two different machines against different databases.
The issue is that on one of the machines the size of SSIS package is displayed as 83 KB and on the other it is 323 KB.Little difference in size is understandable..but such difference is not.
Any idea what's the cause?

Thanks in advance.

What I have tried:

I took both packages (from different machines) and compared them task by task. Everything's same.

推荐答案

我在比较工具中打开了两个软件包，发现软件包有不同的 PackageFormatVersion 。值为3和8. 3参考SQL2008和8到SQL2014 / SQL2016。

这是链接：

我的SSIS包有哪些SQL版本？ | SQL研究

I opened both packages in a comparing tool and found that the packages had different PackageFormatVersion. the values were 3 and 8. 3 referrig to SQL2008 and 8 to SQL2014/SQL2016.
Here's the link :
What SQL version is my SSIS package? | SQL Studies

这篇关于如何在两台不同的机器上使用相同的SSIS包？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！