Hi,
I am using DTS in SQL server2k
What is the best way to insert CSV records, where 1 record maps onto multiple tables with parent/child or PK/FK relationship.
eg.
CSV record
(ID, param1, param2, param3)
ParentTable(ID as PK)
Param1Table(ID as FK in ParentTable, param1)
Param2Table(ID as FK in ParentTable, param2)
Param3Table(ID as FK in ParentTable, param3)
Currently i am using multiple Transform Data tasks with ActiveX script. But it seems to work slow.
Thanks and regards,
HenryI think I would use a staging table, then use a sproc to slice and dice...
Showing posts with label maps. Show all posts
Showing posts with label maps. Show all posts
Tuesday, February 14, 2012
Subscribe to:
Posts (Atom)