CODEWITHSUNDEEP
ssisssis-2012
Me Cool
Me Cool

Reputation: 59

SSIS package upgrade from 2012 to 2014 issues

I've SSIS packages built in 2012 and now I've migrated those packages into a new Prod system and there Sql Server 2014 installed. The package format version also upgraded from 6 to 8 and executed through SSDT 2014 in VS 2015 and the execution is successful. But when I tried to run through command prompt with batch files, package fails.

I checked the old system the DEXEC.exe was in 110 folder and in the new Prod system the DTEXEC.exe is in folder 120. will it be the cause of failure of jobs.

Please suggest me to get rid of this jobs failure.

Upvotes: 1

Views: 489

Answers (1)

Raj More
Raj More

Reputation: 48018

you need to download the project from the SSIS repository on the Sql 2012 server, upgrade the project and all packages to 2014, and deploy to the 2014 server. just copying the package will not work.

Upvotes: 0

Related Questions