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!!
Printable View
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.