Colby, John
JColby at dispec.com
Tue Aug 17 12:02:46 CDT 2004
The database has nothing other that system tables in it. JWC -----Original Message----- From: James Barash [mailto:James at fcidms.com] Sent: Tuesday, August 17, 2004 12:45 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Where did my data go John, Usually with DTS, the table created will have the same name as the file you imported. IF you are using EM to view the database, make sure you do a refresh to see the new table. James Barash -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Tuesday, August 17, 2004 8:03 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Where did my data go 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com