No DataReader Source in the Data Flow sources in Toolbox

Posted on 2011-10-27
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
    LVL 5

    Expert Comment

    by:Brian Chan
    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

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

    Accepted Solution

    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

    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
    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    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.

    761 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