BIDS newbie pains. I created a staging database and a final
dimensional store database in my local SS2K server. In BIDS I created
two data sources, one based on each database. Then, in my package, I
created a connection manager for each of the two data sources.

Problem is, despite following the same procedures to create both
databases, data sources, and connection managers, the connection
manager type for the connection manager from the staging source is
OLEDB, and for the dimensional store source it is ADO.NET. I want both
to be OLEDB, but I cannot find any way to set this or even see how it
is determined in any of the relevant objects.

Many thanks for any help.