title: LONG text in Oracle cut short by SSIS source?
body: <p>I am migrating a database from an Oracle database to an SQL Server 2008 R2 schema using SSIS. There is a column in one of the oracle tables with <code>long</code> text in it. In order to fit the desired schema I am using an SQL command in the OLEDB source which uses a number of joins to get the desired data.</p>
  
  <p>On migrating instead of the whole <code>long</code> string only the first 100 characters are transferred from the source and the rest get trimmed. After I tried a query without any joins I was able to extract the whole text intact.</p>
  
  <p>While running the query on Oracle client the proper result came out. Please suggest any direct way to rectify the problem? Currently I am using an SQL table temporarily to transfer the data before extracting data from Oracle database with a joinless query.</p>