Well basically I'm using a dataflow task with a flat file source and a recordset destination.

Easy right, the same principles that apply to do this for sql server apply.

My flow...

Nevermind found the solution

OK in the past 72 hours I had 2 major successes involving oracle 11g

1)Working Oracle 11g R2 Enterprise on a SUSE Linux 11 SP1

2)Using SSIS to pump data from Oracle...

Eureka

It worked(well sort off)

Success

If I use and ADO.NET source I can retrieve data from the oracle database (If I use an OLE DB Source it still fails)

1SolSingleSol

2Alpha Centauri ABBinaryAlpha...

OK

After a month or so I'm confronted again with this,

I installed the 64 bit client option Administrator

I installed the 32 bit client option Administrator

I did tnsping to my db, called...

Yeah, should have reckoned

well after 2 days painfully searching (cursing and sweating) I managed to get

a working oracle database on a Linux server

How I did it is still somewhat of...

I don't hate the oracle, I think we're just spoiled by MS SQL Severs which seem to have an easy/straightfoward tools to manage and create databases.

However we must try to...

The laptop has 3.8 GB of workable RAM, I configured the EXAMPLE(orlc) database to ma manual, I replaced the one I intend to use for testing and exercises with one...

today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hours

the best answer i can think off atm is that...

There is an example database called EXAMPLES provided with the 11g installation

if you spend 4 years working only with SQLServer you get indeed spoiled

i'm training to become a general dba (oracle, ms sql server)

I got the OCA books last week and...

I used the enterprisemanager and created a user based on the oe user (in the hr examplke db)

only the tabs are empty under this user

OK the books have finally arrived (after 2 weeks delay and then the postman left them at my frontdoor without waiting for me to come to the door (stupid b-post))

I...

Yeah, I hope so bloody snow is delaying delibvery

Ok got the followinbg problem

I create database Test

On Test I create testUser (using Enterprise Manager), I use SQLserver to log in OK works

I create database Test2

On Test2 I create...