We have a data feed from our SQL Server 2005 Datawarehouse that is feeding
data to Oracle 10g. This feed had been working great for several weeks up
until last week. The load looked to have succeeded except the rows are all
showing up as blank.

We run the package manually, all of the tasks indicate success. There are
no error messages. However, the data doesn't show up on the Oracle side.
There are just numerous blank rows.

In addition, the issue is intermittent. The problem doesn't always occur.

Could the issue be related to the Microsoft OLE DB Provider for Oracle?
This package uses the vanilla version that came with the 2005 installation.
I doubt this is the case since it worked just fine until last week. Should
we point the finger at Oracle?

Any help is greatly appreciated.

Thanks!

Jason Wall

DBA