Exporting data in excel in 64 bit machine

[jannat]

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!!

[skhanal]

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

[bobbo]

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

[jannat]

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