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.
| Author |
Topic |
|
SFAgitator
Starting Member
1 Post |
 Posted - 2003-06-25 : 15:02:45
|
| I have a DTS package that is doing a simple query from a sql server table and placing the data in a mysql table. I've insured that both tables are using the same data types. Problem is, I'm getting a status 6: data overflow error.Has anybody been successful in transforming data from sql server to mysql?TIA,Mark |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-01 : 10:57:38
|
| Nope, but just for kicks, create a new table in MySQL as all text.I'm thinking your problem is a numeric column, and the data is out of range.For example, try putting a BIGINT into a smallint columnBOOOOOOMAnd I don't think the datatypes between the two are really compatable...Brett8-) |
 |
|
|
|
|
|
sql server to mysql problem