Not sure what you are doing wrong, but I'm weary of doing a direct insert from an older version to a newer version, I think thats asking for trouble. ...

Tom I have not seen this happen during a switch from S -> E, I have seen the symptom you speak of though and lookups are fairly sensitive to spaces...

If he's using a default instance then simply openning TCP port 1433 should be sufficient. For a named instance you can look at the errorlog and it will tell...

Have done this many times.

What part is causing you trouble? The passing of the value INTO the next step or getting the value OUT of the previous...

Every time I see NUMA I think about Clive Cussler and Dirk Pitt..

CEWII

While SQL may know about this second NIC it isn't really all that important. This is much more of a networking question than anything.

As long as both NICs are...

I largely agree, the destination components do not have this functionality. You might be able to build a Script Task as a destination to handle it but that is...

I haven't found a good way to work around those check script issues. I have setup SQL 2008 in a mandatory STIG compliant environment and it was a PITA.....

GilaMonster (7/7/2011)

---

Elliott Whitlow (7/7/2011)

---

Once this process was in place for us and the CIO was fully on board. The business was "educated" over time that they were an integral...

BIDS will do the upgrade (generally) but you need all of the packages in the file system, thats the only place they can be edited. As far as doing...

GilaMonster (7/7/2011)

---

Elliott Whitlow (7/7/2011)

---

I was with a large organization that unfortuantely the business analysts were more than happy to throw development under the bus to prevent them from being...

Jeff Moden (7/6/2011)

---

That's just not true, Elliott. Maybe...

steveb. (7/7/2011)

---

I would go for Option 3, depending on what type of database is used, as this cuts out all the middle work and will be easier...

Have you installed the backwards compatibility software from the SQL 2008 Feature Pack? If not do that first.

CEWII

Not a fan of option 1, better to let the database engine do the heavy lifting..

Option 2 is a better option especially if you might need to reuse the structure....