Posts

Showing posts from April, 2017

Version number Retrieval from .Dtsx files

Image
PackageFormatVersion Table When Opening a DTSX package with a Text Editor it contains a property name PackageFormatVersion  < DTS:Property   DTS:Name = " PackageFormatVersion " > 3 </ DTS:Property > This Property contains a value that indicate the version of SQL Server related to this Package, also it could indicate the Visual Studio Version used to develop this package. After Reading this Article From SQLStudies i found this Table SQL Version Build # PackageFormatVersion Visual Studio Version 2005 9 2    2005 2008 10 3    2008 2008 R2 10.5 3    2008 2012 11 6    2010 or BI 2012 2014 12 8    2012 CTP2 or 2013 2016 13 8    2015 To Retrieve FormatVersion from multiple dtsx file. Getting values within dtsx packages If you are trying to read a package version within this package you can access to one of the SSIS  system variables Variable Type Description ------------------------------------------- VersionBuild Int32 The pa