ERROR: To run a SSIS package outside of SQL Server

2019-08-20 08:38发布

I have VS2015 Community and SQL Server 2016 Developer installed. Using the MSFT link, I've ensured to download the latest version of SSDT, which appears to install without error (though, Integration Services do not show in the SQL Configuration Manager). Using previously validated projects that creates and executes SSIS packages, I cannot get the same code to work with the current setup.

The error showing when I debug:

Component: SSIS.Pipeline
Error: To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services or higher.

I've uninstalled, reinstalled, repaired, modified, etc., but cannot get the package to build and execute. Has anyone seen similar issues with the setup mentioned?

2条回答
趁早两清
2楼-- · 2019-08-20 09:03

I have exactly the same issue. I ended up installing SQL Server 2017, SSMS 17.4 and VS 2017, SSDT for VS2017 and successfully run my packages FINALLY! It looks like SQL server and SSDT/VS version has to be "matched". Not sure if they have to be the same version though. But this is quite annoying.

查看更多
可以哭但决不认输i
3楼-- · 2019-08-20 09:17

As per my understanding

You need to install SQL Server and make sure to select Integration Services. Then run DTExec.exe from the new SQL server installation folder.

查看更多
登录 后发表回答