SQL Server 2014 packages from SSDT 2015

▲
-1
▼

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?

sql-server
ssis
etl
sql-server-data-tools
ssis-2014
asked on Stack Overflow Jul 28, 2017 by MrDellimore • edited Jul 28, 2017 by Hadi

2 Answers

▲
0
▼

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

enter image description here

Side Note: SSDT 2013 is the related version for developing SQL SERVER 2014 packages, but SSDT 2015 supports backward compatibility

answered on Stack Overflow Jul 28, 2017 by Hadi
▲
-1
▼

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.

answered on Stack Overflow Jul 28, 2017 by MrDellimore • edited Aug 2, 2017 by Cody Gray

User contributions licensed under CC BY-SA 3.0