Batch file getting failed

Question

Dear All,

I Have  created 1 batch file through which i am copying a files  from remote server to local server.

I am executing that batch file using Execute process task.

when I am running manually , it runs fine, but when  am running through jobs it gets failed and showing bwlo error

Executed as user: MEDUSIND\INMUMBIR$. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  12:18:32 PM  Error: 2012-10-09 12:18:34.44     Code: 0xC0029151     Source: Load data from report server to local Execute Process Task     Description: In Executing "Z:\BI_DATA\TPA\COPY_TPA_FILES.bat" "" at "Z:\BI_DATA\TPA", The process exit code was "1" while the expected was "0".  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  12:18:32 PM  Finished: 12:18:34 PM  Elapsed:  1.482 seconds.  The package execution failed.  The step failed.

Please help in same

Regards,

Vipin jha

---

Thankx & regards, Vipin jha MCP

Answer 1

Hi,

Account under which job is running has access to the specified path?

Instead of copying it from some drive, can you use shared paths like "\\sharedlocation\location\.bat"

---

Rajkumar

Answer 2

Hi rajkumar ,

below is my batch files  for copying and deleting

COPY "\\192.168.10.11\1Key_TPA\DAILY_PRODUCTIVITY\"*.xls Z:\BI_DATA\TPA\DAILY_PRODUCTIVITY
DEL Z:\BI_DATA\TPA\DAILY_PRODUCTIVITY\*.xls

regards,

Vipin jha

---

Thankx & regards, Vipin jha MCP

Answer 3

Your script looks fine. Check whether the SQL Server agent proxy account has access to the above directories. It needs atleast a read access to \192.168.10.11\1Key_TPA\DAILY_PRODUCTIVITY\ and a read-write access to Z:\BI_DATA\TPA\DAILY_PRODUCTIVITY\

---

http://btsbee.wordpress.com/