Post reply

planning DTS

  • December 14, 2007 at 3:04 am

    #127356

    I'm working on DTS (SQL Server Integration Services)

    I created a package.

    How can I plan ths package to be executed at a certain time?

    Patrick

  • December 14, 2007 at 5:23 am

    #760159

    Create a SQL Job and use the command DTSRun to execute the DTS package and schedule it .

    Thanks

    Murali

  • December 14, 2007 at 5:26 am

    #760161

    Hi,

    To make it even easier, just right click on the DTS package ans select "schedule package" and schedule it. A job will be created with the same name as the DTS package.

    Renuka__

    [font="Verdana"]Renuka__[/font]

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

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