I do have a flat file(csv file) which is extracted and loaded to another flat file by its position. For example I do have 3 columns like Record type, Emp number and date with a position constraint. Like Record type is of length 2 with a data type of alpha , Emp number is of length 6 with a data type of numeric and date with a length type of 26 in the format of yyyy-mm-dd.hh.mm.ss.000000.

So my result in the flat file would look like this


I do have two issues

First is I am not able to set the length of the numeric to 6 when I extract the csv file as when I specify the data type of Emp number as numeric then my length is blocked and only the precision is allowed for me to change in Flat file source and also in the Data conversion too. And the result is that there is more spaces added next to this field which is not needed in my output file

Next one is with the datetime --> i am not able to set the length for this one once i set this column with a data type of date time with precision.

With my current result I get the out put like this (I am not able to avoid the blank spaces which comes in between as I am not able to set the length for both numeric and also date time)

01654309 2011-08-
02654039 2011-08-

Please suggest me different ways to handle this issue. I have tried using a staging table in between this process but the issue is still prevailing.

Thanks in advance.