Since it appears my original response didn't go through..

I get your point and will help ya but first..

I am obligated to point out that SQL 2000 is end of life...

Yes, that is correct. I believe in your reading it will suggest using a SQL Command ALWAYS even in cases where you only want to read from a single table.

CEWII

While .Net can call COM objects it often has a problem where the architecture is not the same as the caller (x86 vs x64). In SQLCLR this is actually...

I think the point that really needs to be brought is that no new development should be done in DTS and especially in SQL 2000. SQL 2000 has been...

Sorry man..

I can't tell you if it's an in process dll or not b/c I don't know exactly what you mean by that...

Depending on where the package runs wold make a difference. If it is ON the same box as the receiving SQL Server it would almost certainly use the Shared...

I'm about 100% sure you are screwed. I am assuming it is an in-process dll? If so I don't think you can use it.

CEWII

opc.three,

Well said.

CEWII

Is this a one shot? Is it in house? If so I think you *might* be worried about a fairly marginal risk.

However, if this will happen regularly.. ...

opc.three,

I agree there IS some complexity BUT it isn't really all that complex. There are some great how-tos and even BOL does a really good job.

Straight queueing it may...

opc.three (5/2/2012)

Elliott Whitlow (5/2/2012)

SQL Kiwi (5/2/2012)

Perhaps. I think...

SQL Kiwi (5/2/2012)

Perhaps. I think the last time...

I have not seen this behavior and couldn't duplicate it. I'm thinking bug. I also noticed you are running 10.50.2806 which I read as CU5. Not sure...

Why are you truncating the fact table?

Why...

SQL Kiwi (5/1/2012)

It might be; I don't know enough about the requirement to say. That's why I...