How to Call EXE file from SQL SERVER 2005?

I want to call external exe file from SQL Server 2005.. Say for exampl

Page 1 of 1

2 Replies - 4087 Views - Last Post: 07 October 2009 - 06:20 AM Rate Topic: -----

#1 Manisankar  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 06-October 09

How to Call EXE file from SQL SERVER 2005?

Posted 06 October 2009 - 06:27 AM

 I want to call external exe file from SQL Server 2005.. Say for example i want to call notepad.exe.how to do that?
I have tried xp_cmdshell but it's executing successfully but no result.
can anyone please guide me?

Is This A Good Question/Topic? 0
  • +

Replies To: How to Call EXE file from SQL SERVER 2005?

#2 motcom  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 290
  • View blog
  • Posts: 1,371
  • Joined: 16-June 08

Re: How to Call EXE file from SQL SERVER 2005?

Posted 07 October 2009 - 04:49 AM

Hi,

as far as i know thats the way to do it.

You might have to configure your "surface area configuration for features" to enable xp_cmdshell.

I noticed that when using xb_cmdshell to open notepad, it does not show notepad, but when i click cltr+alt+del, it shows under processes.

Anyhow, enabling xp_cmdshell is not a good idea, as this could make your system vulnerable and less secure....
Was This Post Helpful? 0
  • +
  • -

#3 Manisankar  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 06-October 09

Re: How to Call EXE file from SQL SERVER 2005?

Posted 07 October 2009 - 06:20 AM

Hi,
Thanks for reply, Actually i want to run  a VB EXE from SQL which will do data insertion. I Have tried it through SSIS Package using by Excute task process tool.Now the EXE is running after ran the package.
But the problem is now i can't schedule it,If i schdule it, it's hangs.


Was This Post Helpful? 0
  • +
  • -

Page 1 of 1