DTS/import - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS/import

Author

Topic

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2001-12-04 : 05:44:04

Production environment:SQL 7.0 SP1 NT4 EE Cluster
Test environment: SQL 7.0 SP1 NT4 EE
Database: Compatibility mode 6.5

I have a DTS Package that import on the test server the database of the production server.
On the production server I have a table with 1600 rows and a dimension of 130 MB.
On the test server the same table has 1600 rows but only 30 MB of size.

Here is the table:

Column name Datatype Lenght
a1 shrsCode(Varchar) 15
a2 image 16
a3 datetime 8
a4 timestamp 8

There is a clustered index.
Fill factor 90%.

Is it normal so much difference in size between the table on the production server and the table on the test server?

Indexes are the same on both databases (Prod and test) and it is the only table "out of order".
The other tables are exactly the same,same rows and size.
In fact we have this db on a prod server and we do a DTS import to a test server.On sunday we rebuild the indexes thru maintenance plan.So these 2 dbs are exactly the same.Same tables,same indexes,same maintenance.
Another more than strange thing I see this morning:
the name of the clustered index on the production server is different of the one on the test server.

BTW, we have already re-index on the production and on the test server and the strange situation is that on the production server (where the db is big) I have a "SCAN DENSITY" value = 100% and on the test server (where the db is smaller) it is much more bad with a value of 45%.

The log of the Import operation write:

::Error::
Transfer Status: Transferring Data: (Table '[dbo].[tPersonMisc]')
Data truncation occurred in table [dbo].[tPersonMisc], column 2.

::Error::
Transfer Status: Transferring Data: (Table '[dbo].[tPersonMisc]')
Data truncation occurred in table [dbo].[tPersonMisc], column 2.

and so on...always same error.

Any idea?

Thank you.
Franco

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2001-12-04 : 09:04:19

Is it not just a case that the tPersonMisc field is not big enough in the database your are importing in to. Thus the data is being truncated. Did it work on the test server ? What are the field sizes ?

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2001-12-04 : 10:43:46

Thank you for your answer.
I have just create a new database on the test server and try to import the database of the production server.
The dimension of the db is the same.
Size of field are:

a1 shrsCode(Varchar) 15
a2 image 16
a3 datetime 8
a4 timestamp 8

The Import operation fail.

What am I doing wrong?
Franco

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources