Exporting data in excel in 64 bit machine

Hi,

My company moved to Sql 2005 and our Os is 2003 64 bit. I am having problem with exporting data in excel thru SSIS package, can anyone please help?

Thanks in advance!!

What error message are you getting?. Also where are you running the package, on server or your pc?

SSIS is a serious pain. I develop on Visual studio on 32bit server and deploy to 64bit server. One of the problems I encountered is that there is no 64bit Microsoft OLE DB Provider for Jet which is used for Excel so you must execute the 32bit version of dtexec as follows.

DECLARE @cmdshellsql NVARCHAR(500)

SET @cmdshellsql = 'C:\Progra~2\Micros~2\90\DTS\Binn\DTEXEC /DTS "\MSDB\' + @iPackageName + '" /SERVER MYSQLSERVER /MAXCONCURRENT " -1 " /CHECKPOINTING OFF'

EXECUTE @cmdshellrc = master.dbo.xp_cmdshell @cmdshellsql

Ensure you have enabled xp_cmdshell in the Surface Area Config for Features.

p.s. if this is the worst problem you encounter with SSIS, you're having a very good day

Thank you so much for your help. I will try and let u know.