question

GopiK avatar image
GopiK asked

BATCH file hangs when executes through SQL Job

Hi Guys, We have created one VBS file to convert the Excel file to CSV format and the given VBS file is being executed through Batch file.The batch file executes with the heop of SSIS Execute Process Task. Everything works fine through SSDT/BIDS but the package is getting hanged continuously if we try to run through SQL Job. These are the code Batch File : wscript S:\Batch\vbsExceltoCSV.vbs S:\Batch\Client_200817.xlsx S:\Batch\Client_200817.csv VBS: Set objArgs = WScript.Arguments InputName = objArgs(0) OutputName = objArgs(1) Set objExcel = CreateObject(“Excel.application”) objExcel.application.visible=false objExcel.application.displayalerts=false set objExcelBook = objExcel.Workbooks.Open(InputName) objExcelBook.SaveAs OutputName, -4158 objExcel.Application.Quit objExcel.Quit Even when I try to execute the batch file from SQL Job (CmdExec) , facing same issue. I have tried with both Service and proxy account but no luck. Could you please help me to identify what could be the issue. Regards, Gopi K
sql serversql agentbatch
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.