Re: SLOwly Changing Dimension Object

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


I am using
http://blogs.conchango.com/jamiethomson/archive/2005/06/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:

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B787305-5D0D-4557-A862-86C6591C2A78@xxxxxxxxxxxxxxxx

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


.