Hi, I have a Query which returns a singlw row... say A,B,C,D,E,F are my columns. I need a result set in a Fixed width flat file destination like: HEADER A,B,C, D,E,F

I think that will require some scripting withing a asynchronous Script Component.... how is your VB.net or C#? This is an example of such asynchronous Script Component: http://microsoft-ssis.blogspot.com/2010/12/split-record-with-start-and-enddate.html Yours should look something like string[] columns = Row.YourColumn.Split(','); string myNewRow = ""; for (int i = 0; i < columns.Count; i++) { myNewRow = myNewRow + "," + columns[i]; // Every 3 rows if ((i % 3) == 0) { Output0Buffer.AddRow(); Output0Buffer.YourNewColumn = myNewRow; myNewRow = ""; } } Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I think that will require some scripting withing a asynchronous script component.... how is your VB.net or C#? Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

You may want to read John Welch's blog about Creating Multiple Rows in a Text File from a Single Row. Talk to me now on