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.