SQL Server Performance Forum – Threads Archive

More than 1 insert per source row

Hi, I want to build a DTS package where 1 row in the source table results in many rows in the destination table, depending on the content of the source. To be more sepcific: the source table has a XML-document in 1 of the fields. I need to insert 1 row for every tag in the destination table. Is there a way to do this within a DTS package? Thanks,

---

I think if you write a custom query to read the source table and parse the same to generate the rows that you want to be inserted, you can use the same as input for DTS package. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

---

]]>