> 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@discussions.microsoft.com> wrote in message
>> news:8B787305-5D0D-4557-A862-86C6591C2A78@microsoft.com...
>>
>>> 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

"Simon Sabin" 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
>
>
> > 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@discussions.microsoft.com> wrote in message
> >> news:8B787305-5D0D-4557-A862-86C6591C2A78@microsoft.com...
> >>
> >>> 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
>
>