<div>
Actually I found something in Help (SSIS) that says :<br />
When you connect to an ODBC source by selecting .Net Framework Data Provider for Odbc, the provider is unable to enumerate the tables and views available at the source. Therefore the Copy data from one or more tables or view option is dimmed on the Specify Table Copy or Query page, and you must write a query to specify the data to transfer.<br />
This is the 2005 version. I was able to do it on another server that has 2008. So I guess this is my answer. <br />
<br />

</div>


Actually I found something in Help (SSIS) that says :
When you connect to an ODBC source by selecting .Net Framework Data Provider for Odbc, the provider is unable to enumerate the tables and views available at the source. Therefore the Copy data from one or more tables or view option is dimmed on the Specify Table Copy or Query page, and you must write a query to specify the data to transfer.
This is the 2005 version. I was able to do it on another server that has 2008. So I guess this is my answer.



<div>
I accepted the solution to end the question. The answer was actually what I found under help. Thanks for the response.
</div>


I accepted the solution to end the question. The answer was actually what I found under help. Thanks for the response.

<div>
great, then maybe you shouldn't accept my comment, thanks anyway.
</div>


great, then maybe you shouldn't accept my comment, thanks anyway.

<div>
<div class="content wysiwyg-content">
I am trying to use the import export wizard to import data from an as400 into an sql data base. Copy data from one or more tables or views is grayed out. Why? <br />
The only option it is giving me is: &nbsp;Write a query to specify the data to transfer <br />

</div>
</div>


I am trying to use the import export wizard to import data from an as400 into an sql data base. Copy data from one or more tables or views is grayed out. Why? 
The only option it is giving me is:  Write a query to specify the data to transfer 


Copy data from one or more tables or views is grayed out

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.