SSIS Package on 64 bit machine

debugging

http://blogs.msdn.com/amitlale/archive/2007/12/11/ssis-64-bit-setting.aspx

For the SSIS packages that really don't make use of the 64-bit processor, the SSIS project property Run64BitRuntime can be set to False. This is a instruction to load 32-bit runtime environment rather than 64-bit, and your packages would still run without doing any plumbing work. The property can be found under SSIS Project Property Pages -> Configuration Properties -> Debugging.

Run as SQL Agent Job

http://support.microsoft.com/kb/934653

JobType: Operating system (CmdExec).

Package Path: "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

Other Links

http://bi-polar23.blogspot.com/2008/06/ssis-and-sql-server-agent-choosing.html

http://www.sqlservercentral.com/Forums/Topic541317-148-1.aspx

http://msdn.microsoft.com/en-us/library/ms141766.aspx