SIngle Record to Multiple records Transformation

#1

Hi,

I am looking for exmaples or pointers to do single-to-multiple records
transformations in DTS. This is the scenario:

Source Table:
ID
Text - value1<separator>value2<separator>value3<separator >....
Example of 1 record:
1 A<break>B<break>

The Destination should have the following records:
1 A
1 B

Thank in Advance!

#2

Have a look at this article then

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Arun" <aganesan (AT) esurance (DOT) com> wrote

Quote:

Hi,

I am looking for exmaples or pointers to do single-to-multiple records
transformations in DTS. This is the scenario:

Source Table:
ID
Text - value1<separator>value2<separator>value3<separator >....
Example of 1 record:
1 A<break>B<break

The Destination should have the following records:
1 A
1 B

Thank in Advance!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SIngle Record to Multiple records Transformation

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SIngle Record to Multiple records Transformation - 12-09-2003 , 01:05 PM

Re: SIngle Record to Multiple records Transformation - 12-09-2003 , 02:01 PM