Post reply

Scheduling packages

  • June 4, 2008 at 12:22 am

    #122578

    How to schedule the packages to be executed ?

  • June 4, 2008 at 12:55 am

    #824008

    As with a normal SQL Agent job, just specify the package in one the job's steps.

  • June 4, 2008 at 1:00 am

    #824011

    Add a job in SQL Server Agent and specify the job to run a DTSX Package

    The below link gives you the information

    http://msdn.microsoft.com/en-us/library/ms139805.aspx

    Regards
    Venkat
    http://sqlblogging.blogspot.com[/url]

  • June 4, 2008 at 1:52 am

    #824033

    Pls find attached image showing the option I got after I am trying to schedule the job in SQL Server Agent.

    The MSDN document(step no.6) says that I may get option for selecting the DTExec.exe but as shown in the image, I am not getting that option.

    Kindly guide me.

  • June 4, 2008 at 5:13 am

    #824081

    can you check the version of sql server you are using.

    I'm able to view the selection for a dtsx package.

    I'm using version 9.0

    Regards
    Venkat
    http://sqlblogging.blogspot.com[/url]

  • June 4, 2008 at 5:27 am

    #824085

    I have SQL Server version 8.0.194. I think becoz of that I am not getting the same option u mentioned.

    Thanks for replies.

  • June 4, 2008 at 11:47 am

    #824388

    version 8.x is SQL2000.

    Not sure if that article would be applicable

    ~PD

Viewing 7 posts - 1 through 6 (of 6 total)

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