Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Exporting data using OLE DB Provider

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-13 : 07:38:56
Paul writes "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 Files\Common Files\System\Ole db' directory.

I'll appreciate any help.

Thanks."
   

- Advertisement -