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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy