I am using Visual Studio 2012 with SQL Server 2012 Data Tools installed. For some unexplained reason, my workstation will only run my SSIS code in 32 bit mode. I created a dummy data flow reading from a RAW file, and writing to another RAW file. Here are my settings: ![alt text] It runs `DTSDebugHost.exe *32` - the 32-bit version, although I have both installed on my machine. ![alt text] Can you help me figure out what I need to do why it is not running the 64 bit version of DTSDebugHost.exe? : /storage/temp/2125-settings.jpg : /storage/temp/2126-dtsdebughost.jpg
You may have already gone through *64 bit Considerations for Integration Services* (
https://technet.microsoft.com/en-us/library/ms141766%28v=sql.105%29.aspx). If the following is true for the IDE as well as the command prompt... > By default, a 64-bit computer that has both the 64-bit and 32-bit versions of an Integration Services command prompt utility installed will run the 32-bit version at the command prompt Then you may be able to correct this by changing the order of the paths in the PATH environment variable: > To ensure that you run the 64-bit version of the utility at the command prompt, you can take one of the following actions: > > Permanently change the order of the paths in the PATH environment variable by placing the 64-bit path (C:\Program Files\Microsoft SQL Server\100\DTS\Binn) before the 32-bit path (C:\ Program Files(x86)\Microsoft SQL Server\100\DTS\Binn) in the variable.