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.
No comments:
Post a Comment