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 |
|
fourier
Starting Member
7 Posts |
 Posted - 2002-06-13 : 02:23:49
|
| I imported an Access database with 7 tables to SQL7.0 using import/export wizard in SQL server.It created all the tables successfully. But managed to convert only data in 3 tables.They don't contain huge data load.Altogether 6MB when in Access.What could be the reason ?Thanx |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-13 : 03:38:04
|
| Most likely dirty data.Rather use Data Transformation Services in the Enterprise Manager Console. It is the same thing, but you will have the freedom to do a lot more troubleshooting. Start of with allowing errors, and enable logging, then have a look at the logs.Make sure you don't have referential constraints on the tables before you start importing. Otherwise you will have to load the tables in the correct order. |
 |
|
|
fourier
Starting Member
7 Posts |
Posted - 2002-06-13 : 06:06:46
|
quote:
Most likely dirty data.Rather use Data Transformation Services in the Enterprise Manager Console. It is the same thing, but you will have the freedom to do a lot more troubleshooting. Start of with allowing errors, and enable logging, then have a look at the logs.Make sure you don't have referential constraints on the tables before you start importing. Otherwise you will have to load the tables in the correct order.
Error message is :Invalid character value for cast specificationWhat could be the reasonEdited by - fourier on 06/13/2002 07:46:45 |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-13 : 09:06:07
|
| Something that is different to the data type sql thinks this column should be... As Dataphile said, Dirty Data....PeaceRickEdited by - RickD on 06/13/2002 09:06:34 |
|
|
|
|
|
|
Acess to SQl 7.0