Post reply

execute dts (not ssis) task against sql 2005 database

  • July 24, 2008 at 7:49 am

    #123363

    is it possible to execute a dts task against a sql 2005 database?

  • July 24, 2008 at 8:49 am

    #847826

    Yes, you can. But you need to install the sql2000 backward compatibility component which you can get for free from msdn website.

  • August 25, 2008 at 12:25 pm

    #862711

    did you mean sql 2005 backward compatibility?

  • August 25, 2008 at 1:38 pm

    #862760

    You can connect from another server that has SQL 2000 and DTS without doing anything else. If you want to run DTS locally on the SQL 2005 server, you need to install the backward compatibility pack as previously suggested.

    It will only run SQL 2000 DTS packages (not SQL 7) and I believe they must have been created by or upgraded to sp3a or higher. Compatibility can be an issue.

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

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