<div>
From what you are described, you are on the Data Flow tab for one of the module in the SSIS package.<br />
<br />
If you are tryig to suck data out of AS400 (which is DB2, right?), then you should use the &quot;OLE DB Source&quot; in the Data flow sources section.<br />
<br />
First, setup a connection from the connection manager. you would need to find out which provider would cater the service to DB2.<br />
<br />
Then, once you are able to connect to DB2 from SQL, you can then use the OLE DB Source to read from the AS400.<br />
<br />
<br />

</div>


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.




<div>
Cannt I use the ODBC provider? until now I couldnt get the data from an OLEDB provider. 
</div>


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

<div>
YES. can it work with odbc provider as well? I am having trouble configuring the OLEDB.<br />
on the other hand also having conversion problems with the odbc.
</div>


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.

<div>
Sorry, I haven't done anything with AS400 imports using SSIS. &nbsp;I was just letting you a potential reason why the DataReader source wasn't available for you in the toolbox.
</div>


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.

<div>
<div class="content wysiwyg-content">
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.<br />
&nbsp;however the DataReader Destination is not missing. <br />

</div>
</div>


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. 


No DataReader Source in the Data Flow sources in Toolbox

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.