I have some DTS packages on SQL Server 2000 which connect to Oracle (Oracle
provider for OLE DB) as the datasource and SQL server 2000 (Microsoft OLE DB
for SQL Server) as the destination.
I have defined a datapump task with some mappings from the Oracle View to
the SQL server table.
I wanted to change some properties of the datapump and I got an error that
the SQL Server provider did not exist for the destination.

Investigating, I now see that there is no "Microsoft OLE DB for SQL Server"
connection available. Not on this server, my test server, my local pc.

If I could replace the provider with SQL Native Client that could work but I
will lose my column mapping which is complicated and easily messed up.

The common cause seems to be the prescence of SQL Native Client - on the pc
because it's a dev pc and I have installed some 2005 database and Studio
products, on the test server for the same reason, on the dev server it might
be the dba playing with msoft reporting services or the like, he can't tell
me.

Saving the package to the test server results in me being unable to open
that package with Designer. (Error mentions the SQL OLE DB
provider/Connection read/General Network Error)

I want my "Microsoft OLE DB for SQL Server" back - can anyone help ?

Thanks all.