SQLTeam.com | Weblogs | Forums

Issue in Executing DTS Package from Command Prompt or Job

sql2008r2

#1

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.
9815060610


#2

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.


#3

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