Have you tried using the "right" and "left" functions?  something like:
LEFT(RIGHT(<string>,6),1)

Can you post some DDL?
Looking at the sample data, it looks like you'd just need to look at the status column and member email.  the other columns sshouldn't matter.

This sounds like a DNS issue to me.  Your DNS server is likely pointing to the old address or prioritizing the old NIC.
You will want to update the DNS...

Something to check is database autogrow.  If the database is growing when you do this import, it will slow things down.  
Another thing you could try that we did in...

Was my solution no good?  It seemed to work with the data you provided...

A sample solution (not an efficient or "good" one but it works with the sample data you gave, but no promises it would work with "real" data, and I imagine...

There are a lot of good articles written pertaining to SSRS and timeouts out there, such as this one:
http://geekswithblogs.net/ssrs/archive/2009/10/30/steps-to-resolve-ssrs-timeout-issues.aspx

There are 2 basic approaches to timeout issues...

I generally tell them that "I am a database administrator; which is a spcific role in the IT industry."  It gives them the chance to ask more questions about it...

I am probably the "odd duck" in the group, but I don't find any software is "just a toaster".
For years, I just used notepad because it was pre-installed and...

My methodology is that NULLs are acceptable if you can justify them.  If I see code where a developer is creating a table and they haven't talked to me first...

Is this a live server?
If so, my first step would be to get a TEST server set up so you can do changes during company uptime and not have...

Pretty sure the only good way to do that is to cast it to a numeric type in the report or casting it as something else inside excel.  
But...