Should involved DTSs be done with an ActiveX Script Task

[jw970170]

I am writting a DTS to transfer data from flat tables and spread it into multiple tables in a star schema from. I am planning on using an ActiveX Script Task to preform the operation. The operation, however, is involved and tedius since so many things must be accounted for. Is ActiveX Script Task the best way to do this or are their alternate methods?

 

[JohnDTampaBay]

You could import the data into a holding table, then use a SQL stored procedure to split it from the holding table into the destination tables. I use this method mostly because I am more comfortable with SQL. VB folks may feel differently. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)