I have set Project Property Run64BitRuntime to True.
when you schedule to run DTEXEC.EXE from command promt
You will get the following error
Description: The connection type "MSORA" specified for XXX connection manager is not recognized as a valid connection manager type.......To fix this you have to run the 32 bit dtexec.exe
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTEXEC.EXE
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. The 32-bit version runs because the directory path for the 32-bit version appears in the PATH environment variable before the directory path for the 64-bit version. (Typically, the 32-bit directory path is <drive>:\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn, while the 64-bit directory path is <drive>:\Program Files\Microsoft SQL Server\100\DTS\Binn.)
Read more at:
http://msdn.microsoft.com/en-us/library/ms141766.aspx
