Ok, here's a new issue. I created a SQL task using the incoming Excel as the datasource, and created a temp table using 'select into'. The problem is,...

I'm not clear with this step:

"No, don't use a temp table...use a real life "Staging" table. Use the "DTT" in DTS to import the file into a staging table...

1:> I've created the ins/upd sets, but I need help creating appropriate lookups & conditions for launching them.

2:> Sounds reasonable. Can I create a #temp table for the upload,...

I'm brand new to the whole DTS scene, and I found the article very helpful. However, my task involves some conditional processing. Could you help me by providing...

I get the error "Column name 'FakeId' does not exist in the target table." I'm working in v7, does that cause the issue?

Right, I think the current system will prevent the users from deleting records (I need to have history that relates to the records anyway). And, they won't be able...

Well, you're right. I didn't explain or think it through. I need to track & archive the data, so I guess I can't reuse the key. What...

Could be you didn't ask a question or provide enough information...

Wow, that's really cool. It's pretty close to what I need, but I think there might be some problems. First, it's going to be used by a "human"...

Ah, I think I've found what I need. I didn't know about the Profiler; it looks like it can tell me exactly what I need to know. Thanks...

Well, that's where I'm getting my information. The task manager shows sqlservr.exe =99%, but I can't find out /what/ is taking all the cpu.

Um, I don't think I have that procedure; is that SQL 2k?

But that doesn't show me which process is using all the CPU (they all read 0).

Well, it's not pretty, but it is fast. So, 2^5 stored procs later +1 master, it's much smoother. Thanks very much for your assistance, and sticking with me...

Ok, so this is only an easier means of viewing things inside the EM; it doesn't have any real bearing on the code. It's not like Oracle where you...