Hello I created a package in SSDT 2015 and I am trying to run it on SQL Sever 2014.
I tried "save a copy of .." and got it saved on the SQL server. When I create a Job and try to execute the package I get an error:
Could not load package "\pl_dump" because of error 0x80131430.
I have been trying to get this working for days and see so many different tutorials and different software to download with no success. Does anyone know how to deploy and run a package from SSDT 2015 to SQL server 2014?
On
As Hadi suggested, I downgraded the package to SQL Server 2014 in the project properties.
I then saved the package on the file system and set the folder security to "everyone" on the server after getting permission issues. I also made sure to set the security of the package and project to encrypt sensitive data with a password.
when creating package using visual studio 2015 you have to select that this package is targeted to SQL Server 2014.
Go To the integration services project properties -> Configuration properties -> Set TargetServerVersion to SQL Server 2014
Side Note: SSDT 2013 is the related version for developing SQL SERVER 2014 packages, but SSDT 2015 supports backward compatibility