[dba-SQLServer] Where did my data go

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






More information about the dba-SQLServer mailing list