I did a export from one database into another database and selected the copy objects option. I selected my table to export and when the export completed I discovered that in the destination the bigint fields had some negative values in them. Its as if they were converted to int during the export. The copy tables/views options does not do this?
Is this abug in DTS

Salik.

Was the destination v7 of SQL Server?

I have seen posts mentioning this problem. Does it do it if you use the
DataPump task?

What SP are your servers?



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Salik" <anonymous (AT) discussions (DOT) microsoft.com> wrote

completed I discovered that in the destination the bigint fields had some
negative values in them. Its as if they were converted to int during the
export. The copy tables/views options does not do this?

The destination version is 2000. but I don't think I have any of the SP's on it at all. Its on my machine. I don't know what SP the source database is on...as I don't have security rights to see the properties of the server

I haven't tried the datapump task..will do when I get time

Salik

----- Allan Mitchell wrote: ----

Was the destination v7 of SQL Server

I have seen posts mentioning this problem. Does it do it if you use th
DataPump task

What SP are your servers



--

---------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP
www.allisonmitchell.com - Expert SQL Server Consultancy
www.SQLDTS.com - The site for all your DTS needs
I support PASS - the definitive, global communit
for SQL Server professionals - http://www.sqlpass.or


"Salik" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:EFEACF0B-D7F3-4D30-ABA1-C9503C7B7953 (AT) microsoft (DOT) com..
completed I discovered that in the destination the bigint fields had som
negative values in them. Its as if they were converted to int during th
export. The copy tables/views options does not do this

when you are inside the Server in QA issue select @@version

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Salik" <anonymous (AT) discussions (DOT) microsoft.com> wrote

on...as I don't have security rights to see the properties of the server.