I need to import a flat file to a SQL db and the issue I am having is that some fields are zero padded.
For example one fields in one row might be 21.0000 and then in the other row it might be 1.0000 or 12345.0000. for some reason when I create the advance columns the data is not being adjust right. my thinking is due to the decimals.
The person that provided the data tells me that the decimal needs to be in the excat postion.
Any ideas Experts???