OK I've attached a text query plan.

I'm not at work right now so I have limited access but I very much appreciate you having a look for me.

I've also edited...

There is more than just a 'can't find connection manager' error in there. There is also:

Transaction (Process ID 53) was deadlocked on lock resources with another process and has been...

I probably won't have the opportunity to compare myself - thats why I read sites like this. But if I do have an insert performance issue, I might consider SSIS...

It's very important to try to get out of the negative mindset when interviewing for a new job. Think of a professional non emotional way to describe your current situation....

For thousands of records performance will not be an issue. But it is good that you are thinking about it this early.

First step is to be certain about whther the relationship is 1:1 or not.

If you are certain the relationship is 1:1 and you are wondering about the benefits of splitting...

I'd be interested in a performance comparison with a simple INSERT INTO / SELECT solution which does not use SSIS.

I suggest one of two options:

A. Use out of the box SQL to Oracle replication

OR

B. Log the changes locally and send them over in batch:

1. Create a log...

Generally speaking (as this is a general question), probably Option 1 as it lets Oracle pick the best way of applying predicates. Under limited circumstances, option 2 will limit the...

I'm pretty sure SQL Server 2005 onwards supports replication to Oracle, which is what you're trying to do.

It looks complicated but it's the 'out of the box' way to do...

This is not going to scale.

This statement:

'select dt_status,prs_dt_birth, DS_TYPE,DW_DOC_ID,DW_ARCHIVE, DW_MOD_DATE from owner.T_SI_CHANGED

Is selecting ALL of the rows from T-SI_CHANGED.... before you even insert anything.

So what happens after a month when...

What an interesting thread. I think there are some excellent insights in here.

What I agree with most is that the effectiveness of the build and maintenance of systems is often...

I suggest you divide and conquer to identify the data with the issue.

Either slice your source file up into chunks and iteratively load it to identify the offending row(s)

OR load...

The problem could be that you don't have 64 bit drivers installed. Packages run in BIDS as a 32 bit process (last time I used it), which can only 'see'...

Since you just want to duplicate the table, you might find it quicker and simpler to just bulk reload the entire table, depending on data volume.