Running 32 Bit SSIS package in 64 BIt SQL Server

• Derek-412704

  SSChasing Mays

  Points: 609

  More actions

  January 6, 2010 at 2:04 pm

  #386049

  I created a SSIS package in 32 bit SQL server and then deployed it to 64 bit SQL server machine. Imported package to machine where Integration Service is installed. When i run the package manually from Integration Service, it runs fine. gets the job done.

  However,when i run the package from SQL agent ( schedular) it fails saying "cannot execute 32 bit package in 64 bit.."

  i even added 32 bit DTsutility to run it in command line,

  "D:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe"/DTS "\MSDB\Package_Name" /SERVER SP2DROMV /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

  i still get error saying

  " option "\MSDB\Package_Name" is not valid "

• thasteve

  SSCrazy

  Points: 2707

  More actions

  January 6, 2010 at 2:15 pm

  #1099920

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

  To run a package in 32-bit mode from a 64-bit version of SQL Server Agent, select Use 32 bit runtime on the Execution options tab of the New Job Step dialog box.

• Derek-412704

  SSChasing Mays

  Points: 609

  More actions

  January 6, 2010 at 3:30 pm

  #1099956

  i have already done that, didn't work.