sql server 2008 - When Trying to Import Old Visual FoxPro Database into SQL receiving "Cannot find column -1" -


I have a ton of Visual FoxPro DB files that I am trying to import into an empty SQL 2008 Express database. When I go through the SQL Import and Export Wizard, everything seems to communicate properly. When I go to the mapping section, I can see the data in the selected FP table by clicking Preview. When I click on mapping or clicking on next I get:

  ================================ ================== Column information for source and destination data could not be retrieved. "Eqr_sellers" - & gt; [DBO]. [Eqr_sellers]: - Column 1 can not be found (SQL Server Import and Export Wizard) ============================== ===== Column 1 can not be found (System.Data) ------------------------------ Location of the program: System. Data on Data Column Collection. Gate_item (Inter 32 Index) on Microsoft. Data Transaction Services Control. Metadata loader MetadataOlder, IDB Connection, IconConnection, String [] StrreshScchans, Datasource Infosys DSI) on Microsoft at Microsoft. In Microsoft STD. .SqlServer.Dts.DtsWizard.TransformInfo.PopulateDbSourceColumnInfoFromDB (IDbConnection mySourceConnection) Microsoft.SqlServer.Dts.DtsWizard.TransformInfo.PopulateDbSourceColumnInfo (IDbConnection mySourceConnection, ColumnInfoCollection & sourceColInfos)  

Any insights Would be appreciated.

What are the data types? Auto-arrangement integer fields are not supported by ODBC connectors I've used before.


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -