Post reply

DTS step sequence

  • November 14, 2006 at 8:06 am

    #91939

    Hello everyone,

    having problem with DTS. I have a package with a lot of connections to retrieve data from different servers. What I need to do is to include SQL task to truncate tables on local server before I collect this data.

    How do I include this task to make it run first?

     

    Thank you for help

  • November 14, 2006 at 11:50 pm

    #671857

    Add an Execute SQL task and put the Truncate Table statements in that task. Then add an On Success or On Complete precedence from it to the next step you want to run.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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