In SSIS configuration properties -> Debugging -> Debug Options -> Run64BitRunTime =True. Even though its enabled true my system runs only DTSDebusHost.exe*32 and not

DTSDebuGHost.exe placed under D:\Program Files\Microsoft SQL Server\110\DTS\Binn .

How to trigger DTSDebusHost.exe*64 for my XML load process ?

hope if its run in 64 bit this issue will be over come.

Kindly someone help on this .

Hi ARUNGANESAN03,

According to your description, you can only debug your SSIS package in 32 bit mode, but you want to debug your SSIS package using 64 bit DTDebugHost.exe.

Based on my research, I think the issue is caused by 64bit SSIS runtime is not installed on your machine. We can verify the issue by seeing whether DtsDebugHost.exe under <Installation Drive>\Program Files\Microsoft SQL Server\110\DTS\Binn or not.

To fix this issue, please install SQL Server and select Integration Services for installation, setup installs all available 64-bit Integration Services features and tools. Then we can set the Debug Options property Run64BitRuntime to True, view the processes in Windows Task Manager to verify the version of DTDebugHost.exe when debugging the package.

Besides, if the issue still existed, it is my pleasure to help you to reflect your recommendation to the proper department for their consideration. Please feel free to submit your situation on our product to the following link https://connect.microsoft.com/SQLServer/. Your feedback is valuable for us to improve our products and increase the level of service provided.

References:
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2014/05/22/ssis-packages-executed-from-visual-studio-business-intelligence-development-studio-bids-design-time-on-a-64bit-development-server-goes-to-unresponsive-state-during-package-execution.aspx
http://dougbert.com/blog/post/64-bit-considerations-for-sql-server-integration-services-final.aspx

Thanks,
Katherine Xiong

Katherine,

Kindly find the attached screen shot above for reference where DTSdebughost.exe is placed under D:\Program Files\Microsoft SQL Server\110\DTS\Binn  but still run time its not picking up the 64 bit debugger.

Kindly advice on this issue.

regards,

ARUN G