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

• Loner

  SSC-Insane

  Points: 21279

  More actions

  November 14, 2014 at 7:13 am

  #301124

  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

• prvmine

  SSCertifiable

  Points: 6968

  More actions

  November 15, 2014 at 6:49 pm

  #1758818

  SQL Server Data Tools - Business Intelligence for Visual Studio 2013

  support Visual Studio 2013 and SQL Server 2014.