[dba-SQLServer] Where did my data go

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 





More information about the dba-SQLServer mailing list