>>>===================================
>>>
>>>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.

The 64 bit version of Windows 7 has broken probably half a dozen of my programs. Not sure about SQL Server.