Post reply

Schedule and run SSIS without using sql server agent

  • August 26, 2010 at 5:16 am

    #239481

    Hi all ,

    I have a curious query .

    I have a SSIS package created for data migration . I would be providing these packages to the client . Now if the client says that he wont be scheduling the packages from sql server agent on his server .Then is there any other way of scheduling ssis pcakeges other than sql agent like batch file or executable file.

    I mean , Is it possible to provide an executable of SSIS packages.

    (There can be multiple servers and multiple databases involved. )

  • August 26, 2010 at 7:41 am

    #1212299

    You could run the package using the DTExec utility and any scheduler you have available, including the Windows scheduler.


    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]

  • August 26, 2010 at 7:47 am

    #1212307

    Right on Alvin, in the end all the schedulers or even SSIS server eventually call DTExec, so there is nothing preventing it from being called directly.

    CEWII

Viewing 3 posts - 1 through 2 (of 2 total)

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