[dba-SQLServer] Where did my data go

James Barash James at fcidms.com
Tue Aug 17 11:45:20 CDT 2004


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





More information about the dba-SQLServer mailing list