There are a number of ways of getting this done. If you edit your DTS packages in SQL Enterprise manager you can add multiple tasks to the same DTS package.
You could run multiple imports of the same file to the separate tables. You could import the file once into a table and then import data from that table into your final tables using subsequent transform tasks. You could write a custom ActiveScript tasks that imports the data to the various destination tables all in one go, splitting the import data across your destination tables as each row is loaded. You can write all of this in one DTS package or each import in a saparate DTS task with the first DTS calling the next one and so on... If what you are importing is a heirarchical data set you can use the parallel data pump task (though there's no UI which makes it a bit of a bugger to work with as you have to do it via VB or VC++) to import header records then line records. This is very very efficient but can be long winded to get up and running. Books online does cover all this though its not exactly easy to find what you're looking for unless you already know what you're looking for. regards Steve Johnston <[EMAIL PROTECTED]> wrote : > Does bulk insert work with multiple tables? > > I ask the question because it appears that it only works with one table. > That's not hugely helpful (IMHO), unless I update the stored procedure > to run off a table instead of from ColdFusion (ie dump data into SQL > Server table via BULK INSERT and then run an SP on it...)? > > Paul > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] Steve Powell [EMAIL PROTECTED] 07971 583792 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
