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.