I am pretty sure that the point of the FK in the first place is to make sure that you do it right.  I don't suggest removing the constraint.  Now...

You could always force the issue with an index hint.  However, if the optimizer is choosing an different index, there is most likely a reason why. (it may still be...

You are restoring the DB to the reporting server every night?  The way you have it setup, you could just restore the logs from the production server.

If you are just...

I re-wrote this post about 5 times.  Trying to find a way to say this nicely. 

I have been doing this for a very long time.  Although that might be...

xcopy still works well.  And I have to agree with one of the other posts.  You are not shinking the file before copy why?

Have you tried to run the query directly in Oracle?  Not saying that it is or isn't the problem, but if the query is slow, doesn't matter what else you...

Vote for RedGate (it is a great product)  Another advantage is you can ignore things that you feel are not important to worry about. (such as updated comments).  Don't mistake...

You will find strong opinions on both points of view.  And in all honesty there are pro's and con's to both approaches. 

I believe that you should NEVER use a...

I agree that blocking looks to be the issue.  Just add, you will need to start the insert FIRST to see the BlkBy value. 

Also, I would strongly suggest you...

Here's the deal.  SQL Server Doesn't keep the information you really want, so there are some tricks to get something that is close.  Is there a specific reason you need...

Realize it has been solved, but very simply..  If you know what the row should look like if it is already there, then I am sure you can create a...

FYI, that plant wouldn't have been 3 mile lsland would it?    I have been a support person for way too many years.  going...

Another option is to write a perl wrapper program.  You can also use VB Script.  Since this is SSIS, I am going to assume SQL Server 2000.  If it was...

Are you kidding?  XP won't even run in that.  1G at LEAST!  If you have to run in that little memory, I would roll back to Windows 2000, but even then...

Msg 1934, Sev 16: DBCC failed because the following SET options have incorrect settings: 'ARITHABORT'. [SQLSTATE 42000]

http://support.microsoft.com/kb/301292

http://msdn2.microsoft.com/en-us/library/ms190306.aspx