any simple example on internet with SCD SSIS object?

building an example I am getting and error:

there must be at least one column of fixed, changing or historical type of
input for slowly changing dimension transform

help appreciated.
thnx,
Alex

Does this sample from SQL 2005 BOL help?

http://msdn2.microsoft.com/en-us/library/ms141662.aspx



--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"alexde" <alexde (AT) discussions (DOT) microsoft.com> wrote

I am using http://blogs.conchango.com/jamiethom...6/06/1543.aspx

the Example works Perfectly well but it does not give explanation how to set
up slowly changing dimension type1 and type2 in the SSIS object.

I've built exactly ( i think so) SSIS package on Campaign table from my db -
everything is ok Except SLowly Changing Dimension object that keeps getting
an error:
"There must be at least one column of Fixed, Changing, or Historical Type on
the input of a Slowly Changing Dimension transform. Verify that at least one
column is a FixedAttribute, ChangingAttribute, or HistoricalAttribute."

on the Mapping Tab it is more descriptive but I am not able to find it by
error # in MSDN:
Error at <mydtspackagename> [Slowly Changing Dimension 3 [5283]: There must
be at least....etc...(see above)...

execution of the package gives the same error.

How/where I CAN Set up Values: FixedAttribute, changingattribute,
HistoricalAttribute
in the SSIS SlowlyChangingDimension object?
thnx,
Alex




"Warren Brunk" wrote:

Hello alex

In the Wizard for the slowly changing dimension the 2 or 3 page (depending
on whether you still get the information page 1) is for setting the "Slowly
Changing Dimension Columns" in here select the column that you are seeing
if it has changed and select what type of change management you want, i.e.
Fixed, Changing or Historical.

This page also explains what each one means.


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

Simon,
I got used to work with "Show Advanced Editor" rather than with "Edit"...

Thnx for the Help!
Alex

"Simon Sabin" wrote: