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" & Server Name
"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
Also had the Job run in 32 bt - Integration Service Pkg - Execution Options - Use 32-Bit Runtime
May 16th, 2011 5:06pm