SQL Server Performance

Export database using OLE DB Provider

Discussion in 'SQL Server DTS-Related Questions' started by wintergrave, Jun 28, 2006.

  1. wintergrave New Member

    Hello,

    I'm trying to export a database using the 'DTS Import/Export Wizard', I need to use the 'Microsoft OLE DB Provider for SQL Server', but it does not appear on the 'Data source' Drop-Down list of that Wizard.

    What can I do to get that OLE DB Provider installed?

    I'm running SQL Server 2000 Personal with SP4 on a Windows XP Media Center PC and I have MSDAC 2.8 SP1 installed.

    I also checked that I have the file sqloledb.dll on the 'C:program FilesCommon FilesSystemOle db' directory.

    I'll appreciate any help.

    Thanks.
  2. satya Moderator

    I don't think it is enabled in Personal edition.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page