The beginning of the doc:  "The OLE DB destination provides five different data access modes for loading data: A table or view. You can specify an existing table or view, or you create a new table. A table or view using fast-load options. You ...

This is way too brief.  The SCD is used for the dimension tables, so how does the transform know whether "a fact table references dimension members that are not yet loaded"?

If you are parsing a text file, you don't need to use the IsNull function to test values you have parsed from that text file since IsNull will return False for an empty string.  (An empty string is not null, of course.)  IsNull will also return Fa...

The links from other MS pages which are labeled "Small Business Server 2011 Essentials" point here. This page is titled "2011 Standard". If the requirements are the same, that's fine, but then this page should be retitled. If the requirements a...

The Values clause ought to get its own topic under Transact-SQL Reference. There was one in BOL for SQL 2008.