[dba-SQLServer] Where did my data go

Francisco Tapia fhtapia at gmail.com
Tue Aug 17 12:32:23 CDT 2004


On Tue, 17 Aug 2004 13:02:46 -0400, Colby, John <jcolby at dispec.com> wrote:
> The database has nothing other that system tables in it.

DTS will always ask you for a database to import to, however the table
name is assumed to be the same as the source.  Right click on your
tables icon in EM and you should see a new table that matches the name
of the source file (unless you changed it to something else).

Additionally when you check the database properties it shoudl have
increased dramatically to have the capacity for all the 3 million
records.

it is also possible that you may have encountered an error and thus
nothing was imported, however the table name will still have been
made.

-- 
-Francisco



More information about the dba-SQLServer mailing list