Using SQL Server 2012 Agent to run a SSIS package created using VS 2013

  • My company created a SSIS package using SQL Server Data tool for visual studio 2013. I deployed the package to a SQL server 2012.

    Then I created a job to run it, it said the package version was wrong. So I changed 'PackageFormatVersion' in the dtproj file from 8 to 6.

    But when I ran the job, I got the message

    Package error: Package migration fro version 8 to version 6 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number"

    Does anyone have any idea how to run the SSIS package under SQL Server 2012?

    Thanks

  • SQL Server Data Tools - Business Intelligence for Visual Studio 2013

    support Visual Studio 2013 and SQL Server 2014.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply