An old trick is to create a composite index with an additional not null column.

Normally, there are no statistics for NULL-values. By adding a not null column you semi-force them...

good to know

Any clue where Select * from CLEAR.CLM_EDIT_WQ_CLM came from?

Is EXTRACT_DATE a date or timestamp?

other sources report making a view so every oracle column is converted to a...

Hello,

You'l have to check some things.

Does the basic oracle connectivity works using tnsping, sqlplus from the server?

Is the server 64-bit? In that case you might need both the 64-bit and...

Apparently changed with oracle 10g

http://decipherinfosys.wordpress.com/2007/04/28/writing-data-to-a-text-file-from-oracle/

No direct unloader

Have a look at the faq

http://www.orafaq.com/wiki/SQL*Loader_FAQ#What_is_SQL.2ALoader_and_what_is_it_used_for.3F

or try to write to "external tables"

Verify that the adtime can be converted to a datetimeformat as you use it to extract the hour & minutes.

select datepart(hour,convert(datetime,adtime,8))

The sqlagent (user) has access to the share?

Almost.

What culprit did your boss fix?

Can you make a connection to the oracledatabase outside SSIS?

or with a case statement

select

CASE

WHEN DESCRIPTION= 'Stop save' then 'gddo'

ELSE 'turr'

END DEP

from CIRC.TAG

a small recap (and in what order?)

you have installed the 32-bit database (was this software only?) at oraclehome1 (not necessary), oracleinstaller not found?

you have installed the 64-bit client at oraclehome2,...

Hello,

*try at dev-environment first*

You have downloaded the full database versions instead of the clients.

You can download the 32-bit client (win32_11gR2_client.zip)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

You can download the 64-bit client (win64_11gR2_client.zip)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Usually install the 64-bit client...

At the server running the SSIS package you already have an Oracle-client installed (otherwise you couldn't make a connection).

The location of the different oracle clients should show up uner "All...

As gathered from the forums SSIS-designer uses the 32-bit driver, when SQL Server actually executes it it uses the 64-bit driver.

Do you have both oracleclient versions installed?

Shrinking should stay. Had an archival run on Oracle leaving 50% free. To shrink it I had to move all the objects to a new tablespace, "shrink" the original and...

Thanks for the input. I'll start with the books online