I've spent almost a day to find a solution for this, but so far no luck.
Here is the problem:
In my SSIS Package I'm trying to export data from SQL server table to flat file destination with fixed length option followed by comma.
Ex: Account Address Zip
123456 ,2525 Est dr ,77077
563 ,12 we dr ,75023
That is an odd schema for a flatfile, but OK. Set the flatfile to be fixed with. Then pad the columns with trailing spaces and a comma yourself. Two methods come to mind.
OLE DB Sourcecomponent to use a SQL statement that does the padding for you ..
SELECT Account + REPLICATE(' ',10 - LEN(Account)) + ',', Address + REPLICATE(' ',16 - LEN(Address)) + ',', Zip + REPLICATE(' ',5 - LEN(Zip)) + ',' FROM MyTable
Derived Column Transformation to do a similar thing.