Solved

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

Posted on 2007-04-03
2
358 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:Hopefulfruit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18843592
Most functionality with ODBC drivers has been removed from the tools in SSIS. Microsoft is pushing the switch to OLEDB drivers. You can still use ODBC drivers but for the most part you have to write your own scripts to accomplish the same the things the tolls provide. Your best bet would be to see if there is an OLEDB driver for the database. Or you can export the data to text files and import the text files using SSIS.
0
 

Author Comment

by:Hopefulfruit
ID: 19422939
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.
0

Featured Post

Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question