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 |
|
Benjamin_suradji
Starting Member
2 Posts |
 Posted - 2003-06-25 : 03:41:44
|
| HI Friends, I am trying to transfer some data from db2/as400 to sql server table using dtsWhen i am transfering it to the sql server, there's an error message :'The number of failing rows exceeds the maximum specified. [dbnetlib][Connection Write (Send())].General Network Error. Check your network documentation.Kindly suggest what may be the problem. Benjamin |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-06-25 : 04:15:39
|
| Could be anything. How's the load on your network?-------Moo. |
 |
|
|
Benjamin_suradji
Starting Member
2 Posts |
Posted - 2003-06-25 : 07:00:41
|
quote:
Could be anything. How's the load on your network?-------Moo.
Almost 60%, but I've already try it too on local workstation.And the same error message shown.Ben |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-06-25 : 07:48:29
|
| Well what it means is that lot of data that you want to migrate doesnt meet the criteria that you would have specified in your transformation task. I have seen that error in past even when there is problem with datatypes between the source and destination. It would pay to check if you are migrating into correct datatypes. If you still get the problem, then plz post the data dictonary for source and destination DB and will help you debug it.. :-)HTH,Samrat |
|
|
|
|
|
|
DTS Problem