 <p>1st thing Id check is- Open up your flat file connection manager, select the column that's being imported and see what the data type is set to - </p> <p><img src="https://i.stack.imgur.com/X3xhM.jpg" alt="enter image description here"></p> <p>Check the Output Column width and increase if its small</p>