• I am using EXCEL in 64bit.

    I am trying to import Excel into sql 2005 table.

    It runs well in SSIS.

    I read the posts, I set the run64bit (or something like that) to FALSE and rebuild the Solution that contained my package.

    (I created the Solution (Package) using FANNY\wgaw on this sql server box (that is 64 bit).

    Then I created the job using cmdexec step and

    : C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /f "F:\Fanny_MissingaDocs_Sln_Packages\FANNYMissing.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW

    The job owner I tried: FANNY\wgaw , SA FANNY\SQLService

    They all gave me the same error as the ones you guys described.

    Wonder why is still happening?