
Learn about the terminology that Microsoft uses to describe software updates.

To work around this issue, copy the DtsDebugHost file from the VS folder to the correct location:Ĭopy "C:\Program Files\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SSIS\140\Binn\DtsDebugHost.exe" "C:\Program Files\Microsoft SQL Server\140\DTS\Binn" When I try to open an old version of an SSIS package I get the below Unsupported. The install was successful and I now have SSDT for VS 2017 installed - version 15.8.9 (as per screenshot) However, I cannot create an SSIS project. The 64-bit version of DtsDebugHost is found in the following location:Ĭ:\Program Files\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SSIS\140\Binn\DtsDebugHost.exe I have downloaded and installed SSDT from Microsoft docs. Latest cumulative update for SQL Server 2017

Check out the latest cumulative updates for SQL Server: This issue is fixed in the following cumulative update for SQL Server:Įach new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. SQL Data Tools In C - Database Creation, Management, and Deployment in Visual Studio IAmTimCorey 159K views 4 years. When you try to debug a SQL Server Integration Services (SSIS) package in SSDT, the DtsDebugHost always starts in the 32-bit mode instead of the 64-bit mode. SSDT Tutorial - SQL Server Data Tools C++ tutorial: C++ Tutorial From. Assume that you install SQL Server Data Tools (SSDT) 2017.
