Thank you, that works very well

Thank you for that method as well Mark. If I'm understanding correctly, this method counts the number of ordinals before the current one -- though I've got to do...

I see you are using the spt_values table as simply a known sequence of numbers. The sql:column() XQuery extension function I've seen before but hadn't understood until now the...

Got it. The disconnect for me was understanding that by deleting the green Data Flow Path I wasn't actually deleting all the column to column mappings previously completed since...

I added a Derived Column Task to the Data Flow and when I edit it I get the informational message "This component has no available input columns." I did...