1

I am Currently using the visual studio 2015 in which my script task runs fine. When i tried to run the same package using DTEXEC util using the command 

C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\DTExec.exe"  /f "filepath"

I am getting an error

The Script Task "ST_7432393ecf7a4af3906ba19425aeb245" uses version 14.0 script that is not supported in this release of Integration Services. To run the package, use the Script Task to create a new VSTA script. In most cases, scripts are converted automatically to use a supported version, when you open a SQL Server Integration Services package in %SQL_PRODUCT_SHORT_NAME% Integration Services. at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj, IDTSInfoEvents events) "

Note :

 My SSDT Version is 14.061021.0
 Sql server version 2016
 Visual studio version 2015
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
aswin
  • 23
  • 9

1 Answers1

2

"C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\DTExec.exe" /f "filepath"

The 120 refers to SQL Server 2014 while script version 14.0 is meant for SQL Server 2016. Your SSIS is probably build with the wrong TargetServerVersion. Check the properties of your project and change it to the correct version.

enter image description here

EDIT: Or if you're using SQL Server 2016 then you need to change the path to the correct version DTExec.exe. If you installed it in the default path then changing 120 to 130 should work.

JodyT
  • 4,324
  • 2
  • 19
  • 31
  • Tks for the answer but still i end up in an error stating-"to run a ssis package outside of sql server data tools you must install standard edition of integration Services" @Jody T can u please help me – aswin May 10 '17 at 10:39
  • Difficult to say but it looks like you don't have the correct version of SSIS installed. You can verifiy this with the SQL Server Configuration Manager. – JodyT May 10 '17 at 11:08
  • tks a lot @JodyT – aswin May 10 '17 at 11:16