January 6, 2010 at 2:04 pm
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 "
January 6, 2010 at 2:15 pm
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.
January 6, 2010 at 3:30 pm
i have already done that, didn't work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply