Ron Moore
rmoore at comtechpst.com
Tue Aug 17 12:26:21 CDT 2004
John, Did you save the DTS package? If so, it should tell you the 'import to' databasename.owner.tablename. Otherwise, you may want to check all the databases for a table with the name of the text file (or the name you supplied). Just for kicks, I would also check the master, model, msdb, pubs, etc. databases. Ron Moore Sr. Database Administrator Comtech PST Corp. Melville, NY www.comtechpst.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Colby, John Sent: Tuesday, August 17, 2004 1:03 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer] Where did my data go 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com