Please dont double post, as its rather confusing...

http://www.sqlservercentral.com/Forums/Topic511134-148-1.aspx

Look at this posting

http://www.sqlservercentral.com/Forums/Topic502370-148-1.aspx

~PD

I use the OLEDB command transformation for updates

For example, I will update field1, field2 where the key is equal.

So the OLEDB command would look something like this

Update sometable set field1...

Any issues with using a trigger?

~PD

Is it only occuring on the one project or on all projects?

~PD

I would say it depends on what the setting is on the Oracle side.

Is it set up to auto commit or not?

~PD

Also, try and create a linked server to the Lotus Notes DB.

Then you can use openqueries. This will allow you to use a normal OLEDB source

Sorry, not much help on...

Yeah, ETL tools normally make you sweat on the small stuff.

Anyone ever dealing with DataStage will tell you how much sweat a "Phantom Error" is.

But the cool thing is that...

The last column cannot be numeric.

P2P SIGN UP STATUS has values of A and E in the content file you supplied

I made the person id 4 bit signed integer

I made the...

awesome

🙂

From a very far and distant memory of Access and SQL I have also seen #deleted sometimes.

Uhmmm, how about trying to refresh your tables in your linked table manager?

Not sure...

Dont forget to look at your execution plans to avoid those scans

Did you check?

Thanks Michael.

I have downloaded TableDifference and am planning to sample it within the next 2 days.

For now, I have a working version of 3 really mean SSIS end to end...

I have a DB2 assignment which I have to start on Monday, so will get the drivers loaded shortly and be going through some similar pains.

Will post as soon as...

Can you please post what a couple of sample values, and what you are setting the value as in SSIS.

A sample file would be first prize