VS 2015 TargetServerVersion SQL 2014

[Martin Bryan]

If I have VS 2015, should I be able to create a package using DFT+ with TargetServerVersion SQL 2014?

I had a package I created in VS 2013 and deployed to SQL 2014. Now I have VS 2015.

I can only make changes if I set TargetServerVersion to SQL 2016, but then I'm unable to deploy to SQL 2014 (I can deploy, but can't run; I get the following errors)

Error: Failed to load task "DFT+ Create Data File From Stored Procedure", type "". The contact information for this task is "Data Flow Task Plus;CozyRoc LLC; SSIS+; © 2006-2016 COZYROC LLC; All Rights Reserved; http://www.cozyroc.com/;0". 

Error: Failed to load task "ZT Zip and Move File", type "". The contact information for this task is "Zip Task; COZYROC LLC; SSIS+; (c) 2006-2016 COZYROC LLC; All Rights Reserved;http://www.cozyroc.com/;1".

Error: The task has failed to load. The contact information for this task is "Data Flow Task Plus;CozyRoc LLC; SSIS+; © 2006-2016 COZYROC LLC; All Rights Reserved; http://www.cozyroc.com/;0".

If I change TargetServerVersion to SQL 2014, I can no longer modify DFT+.

I'm not sure if this should be possible, or if I am doing something wrong, or installation problem maybe, or something else.

Thanks,

Martin

[Ivan Peev]

Hi Martin,

There is a compatibility issue modifying packages using VS 2015 for SQL 2014 when using COZYROC Data Flow Task Plus. I would recommend you use VS 2012 or 2013 to edit SQL 2014 packages with DFT+ .