Thanks for the tip on text drivers, I always forget to try that. Now to take this thread OT: The problem I have with DTS is that I am unfamiliar with how to do advanced data manipulation. In this case, I have to take every row of the text file, make a new county entry, take the identity for the city table, make a new entry for the city table with the county identity as a foreign key, and so on down the levels until I get to the zip table. And, of course, avoid multiple entries in the county, city and location tables. To make matters worse, I need the full state names in the state table, and the csv only has short state names. So, I have to start with an existing table that I made with stateID, name and short name for the states and reference this when inputting the counties. All this without any knowledge of how to set up advanced stuff in DTS. If you have a couple of key words for me to search for when looking up help in DTS, based on what I need to do, that would a big help.
Or, is there a site somewhere with DTS packages for download similar to the MM developer's exchange? Bill Henderson [EMAIL PROTECTED] > -----Original Message----- > From: jon hall [mailto:jonhall@;ozline.net] > Sent: Monday, October 21, 2002 12:03 PM > To: CF-Talk > Subject: Re: Really big file manipulation > > Well DTS, possibly using cursors if you need to manipulate the data in > some way would be the best way imho, but other than that, using an ODBC > Text DSN would be a decent way to handle the job with just CF. > > Set up an ODBC Text datasource for your csv file. Then select all > records out of the file into a query (it's blazingly fast), and use > CF's query of queries to manipulate the data, then insert...or write > out new files that map directly to the tables and use dts to run the > import... > > Honestly though...using DTS is really the best way. If nothing is > being done other than inserting data into the right places and maybe > some string manipulation, SQL Server provides all the necessary tools > to do this very fast. > > -- > jon > mailto:jonhall@;ozline.net > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
