SQLTeam.com | Weblogs | Forums

Issue in Executing DTS Package from Command Prompt or Job



I was referring your blog for running DTS package from command prompt. I am using following SQL Server version:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)

Now, I am getting the following error while executing the same:

"Excel Connection Manager is not supported in 64-bit version of SSIS as no OLEDC provider is available. I am trying to export SQL Data to Excel through SSIS package. I am attaching DTS package for your reference with this mail.
Please help.


From MSDN:
On a 64-bit computer, Integration Services installs a 64-bit version of the dtexec utility. If you have to run certain packages in 32-bit mode, you will have to install the 32-bit version of the dtexec utility. To install the 32-bit version of the dtexec utility, you must select either Client Tools or Business Intelligence Development Studio during setup.


On your workstation, under project properties, set run 64 bit to false.
on the server, set execution options run as 32-bit