Hopefulfruit
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER