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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics