SQL Agent Hungs with SSIS Batch File

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » SQL Agent Hungs with SSIS Batch File

SQL Agent Hungs with SSIS Batch File

Topic RSS Feed

Posts under the topic: SQL Agent Hungs with SSIS Batch File

Posted: 4/5/2012

Jedi Youngling 30  points  Jedi Youngling
  • Joined on: 6/23/2011
  • Posts: 15

I am trying to execute a batch file from an execute package task in SSIS through sql agent and I am not getting a response from sql. The job appears to run forever.

I also try to open an exe from sql agent but I am getting the same response. The batch files I am executing runs a exe.

I did the following but still no luck:

Went into IE -> ITools -> Internet Options -> Security -> Local Intranet -> Sites and added the server where the executable is.

 

Any idea on what I should do?

Thanks.

 

 


Posted: 4/18/2012

Jedi Master 5325  points  Jedi Master
  • Joined on: 10/27/2009
  • Posts: 298

Do you get any errors at all?


Page 1 of 1 (2 items)