如何确定 SSIS 包 (.dtsx) 是由 BIDS 2005 还是 2008 创建的? [英] How to determine if an SSIS package (.dtsx) was created by BIDS 2005 or 2008?

问题描述

是否有确定的方法可以确定 .dtsx 文件是使用 BIDS 2005 还是 BIDS 2008 创建的?

Is there a sure way to determine if a .dtsx file was created using BIDS 2005 or BIDS 2008?

如果需要知道，我将使用 BIDS 2008 打开包.但我想事先知道它是否最初是通过 BIDS 2005 创建的.假设我没有文档并且我'我将负责记录我们拥有的大量 SSIS 包.感谢您的帮助！

If it needs to be known, I'll be opening the packages with BIDS 2008. But I'd like to know before hand if it was originally created through BIDS 2005. Imagine that I don't have documentation and I'm going to be responsible for documenting the tons of SSIS packages we have. Thank you for any help!

推荐答案

是的.您的 DTSX 中有一个 DTS:Name="PackageType".将您的值与 MSDN 中的枚举进行比较:http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtspackagetype.aspx

Yes. There is a DTS:Name="PackageType" in your DTSX. Compare your value with the enum from MSDN : http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtspackagetype.aspx

A 5 表示 BIDS 2008.

A <DTS:Property DTS:Name="PackageType">5</DTS:Property> means BIDS 2008.

这篇关于如何确定 SSIS 包 (.dtsx) 是由 BIDS 2005 还是 2008 创建的?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！