• We already attempted to create the line break ASCII characters as part of the SQL Statement but then it just became too difficult to build a top down query using variables.

    The trick with doing it in the SQL statement is the decision criteria passing through to the next row. Once you realise that you need to then create a looping dynamic SQL statement so you can assign the ID from the first row and pass it through to the second row and so on for checking if a blank line should be inserted.

    It was all too hard in the end with type matching, variables and While loops for dynamic top down SQL.

    Much quick and easier doing it through a script task and so much more potential for changes, data manipulations, etc...

    Thanks for the idea though.