>>===================================
>>
>>Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)
>>
>>------------------------------
>>Program Location:
>>
>> at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
>> at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
>> at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
>> at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
>> at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
>> at System.Data.OleDb.OleDbConnection.Open()
>> at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
>> at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)
>>
>>--------------------------
>>So, it's possible that VFP tables import is broken with R2.
>
>
>
>I just tried here on my 2008 (w/o R2). 32 bit version:
>The result is 1:1, one table imports successfully the other one didn't.
>I suspect that this table (not imported) has Date fields and I didn't MAP them.

I think the problem is that I use 64 bit version of SQL Server.

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

In any case, the error should be more descriptive, I believe.