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 |
|
lis_ar
Starting Member
5 Posts |
 Posted - 2004-04-22 : 17:33:56
|
| Hello! I'm importing data from VFP, using DTS, but at last of procedure show me the follow error:"Insert error, column6('nhcurcre',DBTYPE_NUMERIC),status12:Invalid status for bound data." Somebody, have some solution?Thanks by your help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-22 : 17:46:10
|
| Is that a VFP error or a DTS error? For column 6, what is the data type in VFP? What is the data type in SQL Server? Are you using the wizard? If you are, I would first create your tables in SQL Server how you want them. Do not let the wizard create them for you. Then I would import the data from VFP using DTS. Your problem is most likely with the data type that SQL Server created for you.Tara |
 |
|
|
lis_ar
Starting Member
5 Posts |
Posted - 2004-04-22 : 17:56:27
|
| That's a DTS error. The type of data in VFP is numeric 4,1. I'm using the wizard. I going to follow your answer, but have other columns of the same type of data and don't show error by these columns. I'll write abuout the result.Thanks |
|
|
|
lis_ar
Starting Member
5 Posts |
Posted - 2004-04-22 : 18:17:28
|
| All right! Thas was the solution to my problem. Thanks, again. |
|
|
|
|
|
|
Error to import data from VFP to SQL