asked
exporting data from ssis to csv having 16+digits..
I am trying to export data from SSIS oledb source to csv file.For a number having 16+ digits, 16th onward digits are converted to "0". How to handle this scenario. I have tried keeping apostrophe at the beginning of digit but that is not helping. Please suggest.Thanks.
Check the data field mappings. Sorry, my language may be not quite right, but I believe that the gist is this: * When you create a data flow / data transfer task, SSIS looks at the top few lines of data in order to determine the types of data being returned * This then informs its choice of internal data representations when building the data flow * If you look at the data mappings in the data flow task, you can see what the internal representations are, and, crucially, edit them. [This Simple-Talk post][1] might be of use in translating my ramblings to your reality. [1]:
https://www.simple-talk.com/sql/ssis/working-with-ssis-data-types/
18 People are following this question.
