Thanks for the idea. I didn't use try-catch since I used -errorvariable in my statement, so instead of calling the throw right after the error occurrs, I waited until...

Great article Erin!

Do you have any recommendations on good 3rd party tools for baselining?

The link to the article does not work. Anyone know where to find it?

Not really. We did find that if we asked the application owner to force a change then it would resolve. At least that way we didn't have to...

That's what I thought. Thanks!

Thank you for your response. Since this will occur after hours I believe the DBs in high performance mode should be fine - I'll just watch the log usage...

Right, I'm so confused now and I thought I had it figured out!

Elliot - Genius! I don't know why I didn't think of that from the get-go. I guess I didn't realize SSIS could make the direct connection. I'm...

Thanks for the reply.

I can't do the four-part notation because the table is not associated with any local database.

It's like this: MyLinkedServer..OracleSchema.OracleTable

I did try your suggestion anyway with the...

Thanks. I'll review the blog.

Very helpful, thank you.

I'll look into it. Thanks.

Are you referring to perfmon? I only see an option for transaction...

Did you ever find out the issue? I'm experiencing the exact same thing.

Thank you for the info. I will look into this.