Sql 2005: Scheduling a job Fails -32 bits on a 64 bits CPU - Need Help

[azziuhc]

Using: SQL 2005 on the server
login: sa (administrator)

I am trying to schedule an export to excel.
It works fine when executed manually but when I tried to schedule a job it Fails.
I know that the problem is between our server SQl (which is 64 Bits) and Excel using 32 bits.

How can I resolve this. I tried everything but need HELP.

This is what I do in detail:
- Select the database
- Tasks
- Export
- select sql
- enter login.....
- Select Microsoft Excel
- select the table
- saved the package under msdb
- execute OK

I schedule the job via:
steps: Integration services
- enter login as sa (administrator)
- select the package
- the go to schedule and schedule once a day.
save it as job1

when I tried to start the job it Fails.
I even followed microsoft:
(

http://support.microsoft.com/kb/934653

but it is confusing exactly on step 3)

Please HELP
thank you

 

[mrdenny]

Edit the SSIS package and change the setting for the package to be a 32bit package.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog