locked
SSIS call fails in 64 bit server RRS feed

  • Question

  • SQL server agent has to be executed form a user other than windows admin. A SSIS where an excel file is loaded into a SQL Server table has to be scheduled by a job.SSIS runs fine alone in the server but fails when called by agent job. http://support.microsoft.com/?kbid=918760#appliesto article has this specific error described but in a 64 bit server this error cannot be rectified. Any ideas?

    Thursday, September 20, 2007 11:43 AM

Answers

  • Currently there is no 64bit driver for excel.  You need to execute the package using dtexec to call the package using 32bit.  In sql server agent set the type to 'Operating system (CmdExec)' and then set it something like this...

     

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

    Thursday, September 20, 2007 12:37 PM