John W. Colby
jwcolby at colbyconsulting.com
Tue Aug 17 07:03:23 CDT 2004
I used DTS to extract 3 million records from a raw data comma delimited text file, inserting it into a SQL database. The DTS wizard asked me for the name of the database, the database was built, the wizard spent two hours pulling the data showing me the record count of extracted records... But there's no data table in the database that it created. In fact, looking back on it, I don't remember being asked for a table name. So where did the data go? John W. Colby www.ColbyConsulting.com