I agree DTS is easier and more intuitive (and more online support) than products like informatica or data junction

Depends, do you have DTS drivers for all the source systems? Or will they be providing you with csv's or something?

I agree with a lot of points that have been brought up, especially Amachanic's about workarounds. The next version of SQL server has a rownumber function and I think that...

I truly think that only the real purists would flip out over using a column with an IDENTITY property. While at PASS in Seattle I asked many Microsoft engineers on the...

'=' will almost always be faster than NOT or != (not equal) Check your optimization plan to confirm and also use "set statistics IO on" to see logical IO.

HTH

Haven't tried it but you could try a view that unions multiple queries with different criteria, just a thought

When you run the package manually are you running it from your machine and not the server? Reason I ask is do you have the same driver on the server...

I assume you are talking about 70-019, DW for 7.0. I personnally would not spend time studying for this as it will surely go away with Yukon being released later...

I agree, the logical design you present to the user should be friendly, up to you how you do the physical design, sometimes it is beneficial to keep them the...

These touch on the subject, Kimball's data warehouse toolkit goes into much greater detail on this subject.

http://www.rkimball.com/html/designtips/2002/designtip36.html

http://www.intelligententerprise.com/030201/603warehouse1_2.jhtml

HTH

OK, I'll bite! How about:

Primary Key Manager

Portable Key Manipulator

Package Kernel Mandate

Peak keyset marshaling

Sorry, I don't know, where do you see "PKM" in regards to sql server?

This has some good links and suggestions - http://www.aspfaq.com/show.asp?id=2423

HTH

Highly reccomend you go out and purchase Ralph Kimballs data warehouse toolkit. It's worth it's weight in gold (OK, maybe not that much but very good)

I personally do not use...

I agree with Frank, opening tables in EM and making edits creates an obscene amount of row locks. To prove this, run profiler, open the table in EM and start...

I believe if your SQL service is running you cannot copy or backup the MDF's or LDF's.

HTH