If you can use FTP you can do it via SQL in a variety of ways.
-----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 14 January 2004 11:38 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Bulk Insert Into SQL Server DB 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] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- ** 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]
