No DataReader Source in the Data Flow sources in Toolbox

Posted on 2011-10-27
Medium Priority
Last Modified: 2012-05-12
I am trying to migrate data from AS400 to SQL Server 2008. having recomended to use the DataReader Source I cannt find it in the toolbox.
 however the DataReader Destination is not missing.
Question by:Hagita
  • 2
  • 2

Expert Comment

by:Brian Chan
ID: 37037318
From what you are described, you are on the Data Flow tab for one of the module in the SSIS package.

If you are tryig to suck data out of AS400 (which is DB2, right?), then you should use the "OLE DB Source" in the Data flow sources section.

First, setup a connection from the connection manager. you would need to find out which provider would cater the service to DB2.

Then, once you are able to connect to DB2 from SQL, you can then use the OLE DB Source to read from the AS400.


Author Comment

ID: 37037356
Cannt I use the ODBC provider? until now I couldnt get the data from an OLEDB provider.
LVL 14

Accepted Solution

Christopher Gordon earned 1000 total points
ID: 37037389
What version of BIDS / Visual Studio are you using in SSIS?  I believe ADO.NET Source replaced DataReader Source after SQL 2005.


Do you see ADO.NET Source in your toolbox?

Author Comment

ID: 37037400
YES. can it work with odbc provider as well? I am having trouble configuring the OLEDB.
on the other hand also having conversion problems with the odbc.
LVL 14

Expert Comment

by:Christopher Gordon
ID: 37037684
Sorry, I haven't done anything with AS400 imports using SSIS.  I was just letting you a potential reason why the DataReader source wasn't available for you in the toolbox.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

864 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