Thanks Steve, Currently, I am not aware that it is possible to retrieve the file by DTS (I know how DTS works and how to set it up).
The question was more about how I could create the file to be BULK INSERTed if I couldn't get it on the SQL Server machine via DTS. The insert and DTS side of things for this project is quite easy really. Paul > -----Original Message----- > From: Steve Powell [mailto:[EMAIL PROTECTED] > Sent: 14 January 2004 11:25 > To: [EMAIL PROTECTED] > Cc: Steve Powell > Subject: RE: [ cf-dev ] Bulk Insert Into SQL Server DB > > > 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] > -- ** 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]
