Thursday, February 7, 2013

How to run SSIS 2012 package in SQL2008 environment?

I was working SSIS 2012 package in local environment, but in my production environment SSIS 2008 . When we run the SSIS 2012 package job in SQL 2008 environment, we got error it below.

“-------Description: The version number in the package is not valid. The version number cannot be greater than current version number. End Error Error: 2013-02-05 08:15:43.31 Code: 0xC0016020 Source: Description: Package migration from version 6 to version 3 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.". End Error Error: 2013-02-05 08:15:43.31 Code: 0xC0010018 ------------

so, I have used to created dtexec command in SQL 2008 Job, then I run it fixed. The commands it follows.

C:\Program Files\Microsoft SQL Server\110\DTS\Binn\dtexec.exe /FILE
"D:/SSIS/NAD1.0/Finance/Finance_ControlFlow.dtsx" /CHECKPOINTING OFF /REPORTING