Export database using OLE DB Provider | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export database using OLE DB Provider

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.
I don’t think it is enabled in Personal edition. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.