To know more about PackageFormatVersion pls read bellow post.
http://msbiusefulpostscopynpaste.blogspot.com/2014/10/ssis-how-to-find-version-of-ssis.html
In SQL Server 2005 Integration Services, the PackageFormatVersion property of a .dtsx file is set to 2; in SSIS 2008 and SSIS 2008 R2, the PackageFormatVersion value is to set to 3. In SSIS 2012, the value of the PackageFormatVersion property is 6.
http://msbiusefulpostscopynpaste.blogspot.com/2014/10/ssis-how-to-find-version-of-ssis.html
In SQL Server 2005 Integration Services, the PackageFormatVersion property of a .dtsx file is set to 2; in SSIS 2008 and SSIS 2008 R2, the PackageFormatVersion value is to set to 3. In SSIS 2012, the value of the PackageFormatVersion property is 6.
I guess these kinds of revamped SSIS packages are always useful and effective whenever there is a need to learn more about how and when to utilise them during debugging.
ReplyDeleteSSIS Upsert