32 Bit Executing Operating System(CmdExec) on the server
Hi, i need help with below command - on previous sql2005 server the command worked & now struggling on SQL2008 Server
32 Bit Executing Operating System(CmdExec) on the server
Type: Operating System (CmdExec), Run as: SQL Server Agen Service Account
All i now changed was the location of the DTSExec being in folder "100"
"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /SQL "\Daily\Test Excel" /SERVER "XXX-ABC" /CHECKPOINTING OFF /REPORTING E
Gives me errors with possible reasons: file name or path does not exist,cannot access file, file being used by another program, workbook same name as currently open workbook
It cant be as the packange runs fine on the server when imported in SSIS or BIDS
Please Assist on what i'm doing wrong
May 16th, 2011 10:13am


