I'm trying to input a .csv file it a table within SSMS. On the whole, I've got this working for me, however, the very fist column in the .csv file is data type 'General', and the data inside it is a number is is showing as 1.01E+12, when really the number is 1012345693210
I need this to go into the table as a full number, however when the SSIS package I have previews the data, it shows as 1.01E+12, and also when it imports ot into the table
I need this to be a full number as this number will be used in a join going forward within a script I'll be creating off the back of the table,
How do I change this without changing the .csv file? I cannot change this unfortunately as this comes from an outside source and we do not control the file, and the file will be used to update a table daily so it needs to be correct as it goes in
Would this be a Data Conversion at all within the Data Flow between the Flat File Source and the Table destination? If so, could someone please help explain how as I'm not 100% familiar with it
Thanks in advance for any help!