Excellent article.

I believe these people are just like me when I became a DBA. You never have seen a 3000 line SP, then you are asked to look into it.

The...

Sounds like you need a Fact table for Parts Inventory and 2 dimensions, Customer and Parts, that are conformed to the Sales fact table.

Check out Kimball's website for more ideas...

You can use a Data Conversion component to convert the WSTR column to I4.

Partitioning is mainly for incrementally loading data by say a date column. If the Monthly or quarterly data is new in terms of in the last month time stamped and...

CASCADE was added in SQL Server 2000.

I remeber because in SQL Server 7.0, I wrote triggers to cascade update and delete on 100+ tables in a database, and 3 months...

Not automatically.

You can place code in a report, but that world require some maintenance and lot sof testing.

A Tablix can be used for columns of a Cross-Tab, but I think...

The password has to be in the connection string.

You can also use a multicast to direct the recordset to multiple Destination objects in one Data Flow.

here are a couple of options:

1. Kill any SPIDs with open connection then manually set to Single User mode.

2. Take the database Offline, dettach databawse, copy MDF and LDF...

Why do you need the database in single user mode?

Thomas

A similar question is in this link. scroll down to a followup question where the answer shows some MDX

http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/3a93bff6-0e5f-4e7f-9b6c-686f08ad73fa

The connection manager uses SMO Connection Manager in the Transfer SQL Server Objects Task, which is different than the connection managers for OLEDB, ADO & ADO.Net in the Execute SQL...

I would first suggest reading some articles from the Kimbal group and concentrate on Fact tables - Tranaction, Snapshot and Accumalitve.

You need this understanding to get the measures the...

I agree with happycat, they should be used in a dimension. You can use the Count Distinct MDX function to answer the How Many... question

Thomas

You could also convert (or CAST) the column in the T-SQL from your Source Component, then send through a Data Conversion component before sending to Destination component.

SELECT <columns>, CAST( txtDate...