This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 91%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA8%3C/text%3E%3C/svg%3E)
I have an ssis project that is running perfectly on SQL Server 2019 using x32 bits and i need to run it on x64. I have installed the OLEDB drivers, sql server on x64 both 2019 and 2022 and when i tried to execute it shows this error locally. Also im using Excel connectors in the project and they are installed on x64 as well.
===================================
Failed to start project (Microsoft Visual Studio)
===================================
No se puede crear un host de depuración para el paquete. (Microsoft.DataTransformationServices.VsIntegration)
Ubicación del programa:
en Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(Boolean isRemoteTest, IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
en Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
en Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)
en Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
en Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
===================================
No se puede comunicar con el proceso de host de depuración. No se ha registrado la interfaz IDtsHost. (Microsoft.DataTransformationServices.VsIntegration)
Ubicación del programa:
en Microsoft.DataTransformationServices.Project.DebugEngine.DebugEngine.LaunchDtsDebugHost(Process& process, Boolean run64bit)
en Microsoft.DataTransformationServices.Project.DebugEngine.DtsProgramNode.CreateRuntimePackageInternal(IDtsHost& host, Process& process, Package& dtsPackage)
Hi @Alex-8104,
Have you tried to use VS2022?
Visual Studio 2022 on Windows is now a 64-bit application.
You may try to edit the ssis package in VS2022 and target to sql 2019 and 2022 for a try.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Im using VS2022 also, but i must target it to SQL server 2019. VS2019 targeting SQL2019 works only on x32. But both VS22 and VS19 failed on X64 targeting SQL2019
Hi @Alex-8104,
Change the target server to SQL2019, Open each connection within the package, test Connection and then run the package.