Post reply

Convert SQL 2000 DTS Jobs to SSIS in SQL 2005

  • September 11, 2007 at 5:35 am

    #180819

    Is there some guidance available for converting a SQL 2000 DTS job to analogous functionality in SQL 2005?  The job in question essentially outputs the query results to a text file.

    Thanks,

    Jim

  • September 11, 2007 at 11:54 pm

    #733006

    I think this will help you....

    http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

    See the "The Upgrade Mechanism" section in this article

    Cheers,

    Sur...

    "I have always wanted the best for myself, so that I can give my best to others"

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

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

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