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

Turning off & on logshipping will require reinitialization. (full backup + new logfiles).

Mayhaps is it possible to delete the old data in sustainable batches for logshipping?

be sure that the correct datatypes are used , not relying on implicit conversions

I would choose 64-bit to minimize 64-to-32 bit conversions

What do folks normally use to view the data from a database if Access forms are not use? If this is more of a design question I can ask it...

Enterprise Architect can do ERD but I haven't used it much yet.

http://www.sparxsystems.com.au/