GSquared (7/25/2008)

---

The thing that's "cool" about us 'mericans, is our very lack of "culture". After all, "culture" is what grows in a petri dish when you feed mold, bacteria,...

I defined Bobby in my joke because we're an international audience here. Most Americans know what a Bobby is, obviously the Brits and probably any country that was previously...

You can, I have, in fact I did it twice. I...

I was also working the problem with the Phoenix SQL Server group on their email list, and someone mentioned that they'd never been able to get files with mixed record...

blandry (7/24/2008)

---

All good points offered, but I learned years ago when I got into management that you must, and I mean MUST think outside the box if you want to...

Found the reason for the problem, not sure how I'm going to solve it. Apparently it's a buffering problem: the header record is 80 characters, the detail records are...

I think it's a buffering problem. At the suggestion of our ERP manager, I tried it as a sequential flow: SQL truncate table, import file, DTS parse header, import...

Unfortunately I can't lop off rows because the mapping then fails since the header record and detail records have different layouts.

I did just learn something interesting, though. I created...

Shaun McGuile (7/24/2008)

---

You guys - there is one show you haven't mentioned at all -

Father Ted!:D

To the rest of the world its comedy, to the irish its serious drama 😉

Cath...

There are two licensing schemes, unless they've changed it behind my back: per cpu, and per seat. ...

Almost all of our hardware is from Dell, and apparently the Windows Server software is bound to the hardware. It wouldn't apply if you're under a Windows bulk licensing...

I forgot another comment that I meant to reply to. Some costs can be hidden and quite high: a lot of the servers sitting in your rack might have...

We've just begun investigating this and have three servers for ESX along with about 10 TB of two new SANs for it. We have a lot of servers we...

Unfortunately I can't do that because the detail record layout is different than the header record, and with the mapping changing the import fails.

That looks very neat, but considering the cost of getting into Management Server, I doubt we'll ever see it here.