dbTalk Databases Forums  

Error with DTS

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


Discuss Error with DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin vom Bruch
 
Posts: n/a

Default Error with DTS - 11-05-2003 , 04:53 AM






Moin Peoples,
I have a problem with Export from MSSQL to MySQL. The DTS write INSERT Error
Collumn 5 (DVDB, DBType_STR) DATA Overflow (or something like that In German
is this Datenüberlauf). The item from the tables are identical (means type=
varchar lenght=255) What means this error and where is the problem. One week
ago works perfectly.

Thanks for your help.



Reply With Quote
  #2  
Old   
Hon
 
Posts: n/a

Default Re: Error with DTS - 11-06-2003 , 05:07 AM






you can try to do SELECT DISTINCT in this field(column5)
to browser thru. the data.

this error occur is because of the convertion of data i.e.
from CHAR to INT, smalldatetime can hold date from January
1, 1900, through June 6, 2079. if you have a date not in
this range it will give this err msg.

Hon

Quote:
-----Original Message-----
Moin Peoples,
I have a problem with Export from MSSQL to MySQL. The DTS
write INSERT Error
Collumn 5 (DVDB, DBType_STR) DATA Overflow (or something
like that In German
is this Datenüberlauf). The item from the tables are
identical (means type=
varchar lenght=255) What means this error and where is
the problem. One week
ago works perfectly.

Thanks for your help.


.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.