Alternate for xp_cmdshell

• KumarSN

  SSC Enthusiast

  Points: 196

  More actions

  December 18, 2007 at 10:17 pm

  #71205

  Hi,

  We are currently migrating SQL sever version 97 to SQL server 2005. In our old version most of the procedures call dts packages using xp_cmdshell.

  This is the syntax used:

  select @cmd = 'dtsrun /s /N "DTs name" '

  execute master..xp_cmdshell @cmd, no_output.

  Now we have migrated to the DTS packages to SSIS packages. But as xp_cmshell is not enabled by default in 2005 and enabling it creates security hole, can anyone please suggest some alternate way of calling the SSIS packages from SQL sever procedures?

  Would appreciate any suggestion regarding this.

  Thanks in Advance.

  Sanat

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  December 19, 2007 at 2:27 pm

  #761581

  Can you still create SQL jobs in 2005?

  If so, why not create a SQL job that will execute the package then use sp_start_job to run the job?