sql server 2000 DTS import

  • Hi Guys,

    I tried to use DTS import to transfer data of table to another db. in the data source list, It doesn't have "Microsft OLE DB Provider for sql server" list.

    So I can not use the function to import data by DTS.

    Any suggestion?

    Jchen

  • Strange. You could try to run SQL Server setup and install Client components once more. I just noticed that when client tools for SQL 2000 are installed on machine, Client components are by default switched off when you install SQL 2005.

    ...and your only reply is slàinte mhath

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

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