Cannot create a debug host for the package - SSIS 64 bit error
Question
Friday, August 22, 2014 12:53 PM
All,
I am unable to run SSIS package from BIDS. Its developed using SSIS 2012. When i change the project setting to run in 32-bit, it runs. 64 bit it does not.
Below is the configuration: -
System - Windows 7 Enterprise Service Pack 1 - 64 bit
SQL/SSIS - Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Error details: -
===================================
Cannot create a debug host for the package. (Microsoft Visual Studio)
Program Location:
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)
===================================
Cannot communicate with the debug host process. Failed to obtain child process active object. (Microsoft.DataTransformationServices.VsIntegration)
Program Location:
at Microsoft.DataTransformationServices.Project.DebugEngine.DebugEngine.LaunchDtsDebugHost(Process& process, Boolean run64bit)
at Microsoft.DataTransformationServices.Project.DebugEngine.DtsProgramNode.CreateRuntimePackageInternal(IDtsHost& host, Process& process, Package& dtsPackage)
Could you please help me in resolving the issue? Thanks.
All replies (4)
Thursday, August 28, 2014 3:02 PM ✅Answered
Some components / tasks or drivers require to run in 32 bit mode.
It is a suspect if a simple package say that has an empty script task does not run in 64 bit mode.
In this case I suggest simply to reinstall everything.
Arthur My Blog
Monday, August 25, 2014 5:38 PM
SSIS 2012 packages must be run with SSDT or VS 2010 having the BI support installed
Arthur My Blog
Tuesday, August 26, 2014 9:48 AM
All,
I am unable to run SSIS package from BIDS. Its developed using SSIS 2012. When i change the project setting to run in 32-bit, it runs. 64 bit it does not.
Hi Nagesh,
According to your description, are you using Business Intelligence Development Studio(BIDS) tool to open SSIS package which created by SQL Server Data Tool(SSDT)?
If so, BIDS is integrated with SQL Server 2008R2 or earlier version, but SSDT is intergrated with SQL Server 2012 or later version. Backward compatibility is not supported for SSIS Package.When you create your SSIS Package/s make sure you have same version on other machines where you need to deploy your packages later.
For detail information, please see:
SSIS - Backwards Compatibility For SSIS Packages: http://sqlage.blogspot.com/2013/12/ssis-backwards-compatibility-for-ssis.html
If I have something misunderstood, please point out and elaborate your issue/scenario with more detail.
If you have any feedback on our support, please click here.
Elvis Long
TechNet Community Support
Wednesday, August 27, 2014 10:18 AM
Evis,
Thanks for your prompt reply.
Sorry for the confusion. I have developed and running the package from "SQL Server Data Tools" (Which is in the Microsoft SQL Server 2012 folder in all progams). I get the same error while running from SSDT as well.
Any other suggestions please?