 <p>The dts data Conversion task is time taking if there are 50 plus columns!Found a fix for this at the below link</p> <pre><code>http://rdc.codeplex.com/releases/view/48420 </code></pre> <p>However, it does not seem to work for versions above 2008. So this is how i had to work around the problem</p> <pre><code>*Open the .DTSX file on Notepad++. Choose language as XML *Goto the &lt;DTS:FlatFileColumns&gt; tag. Select all items within this tag *Find the string **DTS:DataType="129"** replace with **DTS:DataType="130"** *Save the .DTSX file. *Open the project again on Visual Studio BIDS *Double Click on the Source Task . You would get the message the metadata of the following output columns does not match the metadata of the external columns with which the output columns are associated: ... Do you want to replace the metadata of the output columns with the metadata of the external columns? *Now Click Yes. We are done ! </code></pre>