Post reply

How to Schedule and Run a SSIS package in A JOB

  • October 7, 2010 at 7:13 am

    #229141

    HI,

    i created ssis package.i want to run the ssis by daily automatilcly .but i dont know how to insert ssis in a sql job .can any one solve my problem

  • October 7, 2010 at 7:20 am

    #1233535

    Save the ssis package to SQL Sever, cick save as..

    In sql server create a new job and add a step of run ssis package, select the package you saved there.

    Schedule the job.

    run a test.

  • October 7, 2010 at 7:26 am

    #1233541

    Hi steveb.

    thanks for reply ...i have a small doubt in which file i want to save the ssis package as dts or in which format

  • October 7, 2010 at 7:41 am

    #1233561

    if you click on file --> save copy of packagename.dtsx

    this will bring up another menu, in here select sql server as your package location.

  • October 7, 2010 at 7:49 am

    #1233571

    SSIS packages are always saved as .dtsx files


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply