I have a query which extracts all the required data from a database and I need to load this data into a Text File. I am using a SSIS package to do this.
Now this file should have data in the format given below
437856785 A20101009This is construction 124728347
i.e the receiving file has no delimiters and each field is determined with a fixed length(fixed number of characters). The data I get out of my query for example for the first column returns just the value 437856785 and I need to append spaces to it
to achieve the fixed length. I need to do to this kind of appending spaces to all the columns. Please suggest me ways to do this.
Thanks in advance..
View Complete Post