March 11, 2004 at 1:26 pm
When trying to use DTS to import a foxpro table into SQL Server, we are having problems with a decimal field. It always fails as soon as a number in the column increases in digits. We have made sure that the SQL table has the correct precision to handle all the data in the foxpro table, yet we still get the error. If we change the data type to integer in the SQL database everything is fine (there happen to be no decimals in the current data.) We always get the error "invalid status for bound data." Has anyone encountered this before?
Thank you
March 15, 2004 at 8:00 am
This was removed by the editor as SPAM
April 18, 2004 at 2:07 pm
I am having the same problem - except my data does contain decimals. I am beating my head aginst the wall here. Any thoughts guys?
Greg
April 19, 2004 at 7:08 am
Actually, we did finally resolve our problem, we needed to upgrade the foxpro driver that SQL Server was using. I believe that we did this, but upgrading our MDAC version.
April 22, 2004 at 4:36 pm
The solution is in create a table in the destination database, with the column respectives, after import with DTS to the created table, and that is the solution.
Lucky
August 6, 2007 at 11:04 am
We just started seeing this problem on decimal columns when importing data into sql server. Does anyone know what the actual issue is? Is it related to MDAC?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply