I finally fixed this. On the job scheduler properties under [STEPS], type is [Operating system (CmdExec)]. If I used the [OPEN] button to navigate to the folder where my batch file resides and I click on it, it copies the command of the batch file to the text box. So I get: d: cd D:\DotNet\SSIS\FCBilling\FCBilling\bin DTExec.exe /SQL "\FCBilling" /SERVER "." /DECRYPT "password" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW Instead of doing this, I specified the whole path of the batch file and it worked. D:\DotNet\SSIS\FCBilling\FCBilling\bin\runme.bat

Run the package using the dtexec from the x86 dtexec that is installed by default. http://msdn.microsoft.com/en-us/library/ms141766(v=SQL.90).aspx Ted Krueger Blog on lessthandot.com @onpnt on twitter Please click the Mark as Answer button if a post solves your problem!

I'm trying to import an excel file into my 64bit SQL server. Runs fine on Visual Studio. Runs fine as an MSDB package on the server. Runs fine if I execute a batch file to call a 32bit version of DTEXEC. *** BATCH FILE *** d: cd D:\DotNet\SSIS\FCBilling\FCBilling\bin DTExec.exe /SQL "\FCBilling" /SERVER "." /DECRYPT "password" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:11:48 PM DTExec: The package execution returned DTSER_SUCCESS (0). Started: 2:11:48 PM Finished: 2:11:56 PM Elapsed: 7.984 seconds HOWEVER, the agent (using an admin proxy) fails to run this package. I get an error: 02/28/2011 13:54:00,FCBilling,Error,1,SQL01,FCBilling,Execute BATCH FILE,,Executed as user: COMPANY\AdminIT. The process could not be created for step 1 of job 0xE673EBC239C9CF4D8C737819006627ED (reason: Access is denied). The step failed.,00:00:00,0,0,,,,0 Any ideas appreciated - thanks.

Please use the 32 Bit setting in the SQL Agent job (the driver for Excel is 32 bit). Image of the setting: http://goo.gl/RPu0cArthur My Blog

Please use the 32 Bit setting in the SQL Agent job (the driver for Excel is 32 bit). Image of the setting: http://goo.gl/RPu0c Arthur My Blog I believe this option is only available for SQL Server 2008. http://msdn.microsoft.com/en-us/library/ms138023.aspx

I finally fixed this. On the job scheduler properties under [STEPS], type is [Operating system (CmdExec)]. If I used the [OPEN] button to navigate to the folder where my batch file resides and I click on it, it copies the command of the batch file to the text box. So I get: d: cd D:\DotNet\SSIS\FCBilling\FCBilling\bin DTExec.exe /SQL "\FCBilling" /SERVER "." /DECRYPT "letmein" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW Instead of doing this, I specified the whole path of the batch file and it worked. D:\DotNet\SSIS\FCBilling\FCBilling\bin\runme.bat