One source row to multiple destination rows 
Author Message
 One source row to multiple destination rows
I'm using a transformation task with an ActiveX VBScript.
(SQL 2000).

Occasionally I process a row in the source (text file)
which I need to convert into 2 rows in the destination

Is there a good way to do this.  (Preferably within the
same script and on the same scan of the source file - but
all suggestions are very welcome.)

Thanks in advance,

Dave McKinney.

Mon, 17 May 2004 16:50:51 GMT
 [ 1 post ] 

 Relevant Pages 

1. Pivoting one source row into multiple destination rows

2. DTS- multiple destination rows for each source row

3. Creating Multiple Destination Rows from a single source Row

4. multiple inserts in destination for each source row

5. Adding Multiple Rows while Transforming from Source to Destination

6. column in multiple rows to multiple columns in one row

7. column in multiple rows to multiple columns in one row

8. Multiple Target Rows from a Single Source Row

9. concatenate varchar field from multiple rows into one row as a group

10. Get values from multiple rows as attributes of one row

11. Combing multiple row data into one row in another table

12. SELECT multiple rows back as one row with many columns

Powered by phpBB® Forum Software