Phil Parkin: Thanks for the encouragement and making me not feel so bad. You are right that I have learned a lot. That's the silver lining.

TL and frederico_fonseca: That is...

kaj: That was a great idea. I'm all about long shots at this point, but this particular shot didn't help this problem. Doesn't matter, because that is something I should...

• This reply was modified 4 years, 4 months ago by  JJ B. Reason: Fixed a formatting problem

Update For Anyone Interested

I figured out how to create a 'Credential' on the server.  The Credential is linked to my Windows account.  Then I created a Proxy which is linked...

Mr Brian Gale:  I love how you think outside the box.  To answer your questions:  I just asked and was emailed back, "Resource governor is not configured on [OurNewServer] and...

Steve Jones and Jeffrey Williams:  Sorry, I've been trying to do tests and typing replies as fast as I can when your posts come in.  So, I'm not responding to...

Jeffrey Williams:

re: "I think you need to be looking at the Sybase system to see what is executing on that system."

That possibility makes sense to me too.  However, I may...

Steve Jones:

re: "If it hangs in SSIS, can you get it to hang in SSMS?"

I think you mean to try this?: Open Integration Services in Object Explorer in SSMS.  Then...

TL:  I found "Disk Queue Length" and watched the number before the package ran.  Before the package ran, the number was mostly zero, with some fluctuations between 0.01 to 0.30...

TL:  Neither the old system nor the new system is Azure.

Here's what I've been told: The old system has 2 cores and the new one has 2 or 4.  (I...

Steve Jones:  At first the job seemed to be stopping at different points.  However, over the last couple of days, it seems to always load the same first two tables...

Jeff Moden:  I don't know what you mean by "check what code is running on the server."

If you mean looking at the profiler, then yes.  After a few seconds, the...

William Rayer:  I should also add for interest sake:  Out of desperation, I did a test earlier where I changed the compatibility level of the local SQL Server database to...

William Rayer:  I'm saving your valuable post, because I think it is going to be relevant and *very* helpful in a couple of months.  I'll tell you why I don't...

Jeffrey Williams:  Thanks for the additional thoughts!  I can respond to a couple points and will have to research/test the rest.

As for the destination database/tables, none of the tables are...

Update For Anyone Interested

I have spent the last couple of days trying to chase theories of memory problems and/or network problems.  I would be happy to share the memory research...