Link to home
Start Free TrialLog in
Avatar of Hopefulfruit
HopefulfruitFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL SERVER 2005 SSIS 'Copy Data from one or more tables or views' is greyed out. ODBC?

I'm trying to Import a database from an ISAM database using SSIS into SQL Server 2005 using the Import Export wizard.  It only allows the use of  ODBC provider for.NET (not standard ODBC) and I have entered filedsn=C:\Program Files\Common Files\ODBC\Data Sources\odbcfilename.dsn as a connection string but once I get to the Specify table copy or query screen in the wizard the option for 'Copy Data from one or more tables or views' is greyed out.

Can you please provide advice.  I think it may be a problem with the ODBC driver for .NET as the option is available when I use the OLEDB driver for SQL to the SQL Server for example.
ASKER CERTIFIED SOLUTION
Avatar of rboyd56
rboyd56

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Hopefulfruit

ASKER

The problem is with the Synergy ODBC driver which interrogates the ISAM database.  There is no OLEDB driver unfortunately and the software vendor who provided the system that runs on the ISAM database are not much help. We just have to live with the tables that we can access and that's that.  Very annoying.