SQL SERVER JOB

• Best-330874

  SSCrazy

  Points: 2350

  More actions

  April 4, 2007 at 9:54 pm

  #116548

  Hi ,

     i need help on this.

  i have created a package in SSIS.What that package does it pulls up data from an excel workbook and gets the data into sql server database.The package runs fine.

  What i need to do further is as follows:

  1. i want to schedule a job and i need to write a stored procedure which executes the package .i need to know.how will i write the stored procedure(syntax).

   

  Any help will be appreciated.

  Thanks

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  April 5, 2007 at 12:53 pm

  #698900

  Why do you want to execute the package from a stored procedure instead of executing it in a job step?

  There are ways to execute a package in a stored procedure.  Check this: http://msdn2.microsoft.com/en-us/library/ms162810.aspx or search this site for "SSIS in stored procedure".

  Greg

  Greg