Hi, I'm trying to import data from SQL Anywhere database to SQL Server 2008. I'm using .NET data provider for SQL Anywhere and .NET data provider for SqlClient. When debugging, the DbConnection.GetSchema( "DataTypes") was called by SQL Server Import and Export Wizard. Our ADO.NET provider supports the same schema data as SqlClient. The query based data transfer works perfectly, but I really don't understand why the 'Copy data from one or more tables or views' radiobutton is alway disabled. Could anyone give me some help? Thanks Minghai

You can check the below document: http://msdn.microsoft.com/en-us/library/ms177262.aspx When you use a .NET Framework data provider to connect to your data source, the Copy data from one or more tables or views option might not be available. This option is available only for those providers that have a ProviderDescription section in the ProviderDescriptors.xml file. Each ProviderDescription section contains the information that is required to retrieve metadata from the corresponding provider. By default, the ProviderDescriptors.xml file contains a ProviderDescription section for only the following providers: · System.Data.SqlClient · System.Data.OracleClient · System.Data.OleDb · System.Data.Odbc To make the Copy data from one or more tables or views option available for additional providers, third parties can add their own ProviderDescriptor sections to the ProviderDescriptors.xml file. By default, this file is in <drive>:\Program Files\Microsoft SQL Server\100\DTS\ProviderDescriptors. To review the requirements for the ProviderDescriptor section, see the ProviderDescriptors.xsd schema file that is, by default, in the same folder as the ProviderDescriptors.xml file. Hope this helps, Raymond Raymond Li - MSFT

Where can I find an entry for the .NET MySQL provider? The .NET ODBC Driver (with the MySQL ODBC driver and system DSN) is not mapping the field types correctly, and worse yet, the system has degraded into a state where I cannot even select the System DSN without getting an error it wasn't throwing before: "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified", even though I specified the exact name of the System DSN I created "MySQLw", and the exact driver name of the installed driver associated with that DSN "MySQL ODBC 5.2w Driver".