Storing Export proceedures.

• jdnormanpurdue

  Newbie

  Points: 3

  More actions

  April 18, 2008 at 6:32 am

  #189453

  I need to export a set of records weekly right now I am running the wizard each time and repeat the same work to get it to a flat file. Is there a way I can store my procedure? I am still learning SQL Server having learned Oracle in college.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736632

  More actions

  April 18, 2008 at 8:11 am

  #804375

  There is a check box in the wizard to "save the package", which will save the SSIS package that you can rerun.

• tbeadle

  SSCommitted

  Points: 1635

  More actions

  April 21, 2008 at 1:07 pm

  #805160

  [font="Arial"]

  Hello,

  Another way is to create a .bat file that calls osql which in turn will execute your stored procedure.

  This .bat can be added to a scheduler software that will execute it on the schedule of your choosing.

  If your stored proc needs parameters, the .bat can provide them and some scheduling packages have that capability too.

  Regards,

  Terry

  [/font]