You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Allow for the extraction of a singular value into a variable. Much like with the "Execute SQL" task in SSIS where you can either have "multiple results" which is how the EBCDIC Source works today, or you can specify 'Single Row' which allows you to extract a single value or values into destination variables. This would be handy for situations where you are trying to extract information from a header or trailer. You don't need to be able to read all the data in the file and you don't need to have a sophisticate output setup, just read the file and allow the single row to be mapped to specific variables. Maybe this would be better implemented as a Control Flow component instead of Data Flow component because the output isn't going to a data destination, it's just going to an SSIS variable.
The text was updated successfully, but these errors were encountered:
Allow for the extraction of a singular value into a variable. Much like with the "Execute SQL" task in SSIS where you can either have "multiple results" which is how the EBCDIC Source works today, or you can specify 'Single Row' which allows you to extract a single value or values into destination variables. This would be handy for situations where you are trying to extract information from a header or trailer. You don't need to be able to read all the data in the file and you don't need to have a sophisticate output setup, just read the file and allow the single row to be mapped to specific variables. Maybe this would be better implemented as a Control Flow component instead of Data Flow component because the output isn't going to a data destination, it's just going to an SSIS variable.
The text was updated successfully, but these errors were encountered: