Fill blanks paces in fixed width output file using ssis derived column

Question

Hi All,

How to fill spaces in a text file using ssis derived column. Do we have any space() in ssis to use in derived column

I have to write output file like this..its fixed width file 0f 45 length.

abcd1234567890   ( i need blank spaces here)

ab1111111111111111111122222222222222222223333                                     

Please give me some idea how to fill balnk spaces in fixed width outputfile. Its very urgent

Thanks,

RH

---

sql

Answer 1

If you have declared a fixed width output file then you don't need to pad it, it happens automatically.

---

Chuck