DTS import table problem

#1

Hi All,

Recently I am experiencing problem when in Enterprice
Manager using import a new table from another SQL 2000
server. The task completed with no error, but the record
count is different, the destination table is always has
more records. Is anybody experience the same problem?
Thank you in advance

Mitch

#2

Now that is strange and shouldn't happen

Can you send a very simple repro

What is the Source?
What is the destination?
Do you do anything special?

Are you sure there are no records in there beforehand?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

#3

Most probably EM is lying to you. The figures you see are not what are maybe there.
If you use QA and ask for a count on bith tables do they match ?

Look at this

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsqlref.chm::/ts_dbcc_24rp.htm

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

#4

So it is not that you more records in the new server, it is just that the
recordcount reported by em in the old machine is different.

This is because EM relies on the table statistics, rather than running count
in each table.
run sp_updatestats on the source server and you will find that em now
reports the correct recordcount.

HS

"Mitch Hahn" <mhahn (AT) gtis (DOT) com> wrote

Quote:

Hi Allen,

Thanks for replying.
Source: SQL 2000 (sp3) On Windows 2000 server(sp4). In enterprise
manager right click on table property, record count:251,184,872.
Destination: Brand new machine. SQL 2000 (sp3) On Windows 2000
server(sp4). After importing, record count: 251,185,904.
I did not do anything special at all just stright import data table. But
if I run a query to tally the record count on both tables, results are
the same: 251,185,904 records.
Any ideal? Thanks.

Mitch

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#5

Thanks you all.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS import table problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS import table problem - 08-08-2003 , 08:41 PM

Re: DTS import table problem - 08-09-2003 , 12:29 AM

Re: DTS import table problem - 08-09-2003 , 07:38 AM

Re: DTS import table problem - 08-09-2003 , 12:30 PM

Re: DTS import table problem - 08-09-2003 , 07:04 PM