Normalizing the data

Hi,

I have a table like this:

Col1 First_Year Last_Year
a 1990 1993

I want this data to be converted to
a 1990
a 1991
a 1992
a 1993

Is there any simple way to do it in SSIS without using Script Component?

Thx

No - you'll need to use script.

There are components for pivot and unpivot, but not for imputing missing members of a series.

Donald

|||

Thiru_, you can use DataDefractor SSIS source data flow component to accomplish this with no programming. This component pivots and normalizes fact data and dimensional metadata located in unstructured and semi-structured matrix data sources. You can download a free beta of the component at http://www.datadefractor.com.

sql