Solved

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

Posted on 2007-04-03
2
345 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
2 Comments
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now