I have a text file 开发者_运维问答with 5 columns and a variable amount of rows. What would be the easiest way to grab the first row of the text file and set 5 different variables in SSIS to the values of the 5 columns in the first row?
- Define your five variables in the package, and one more for row_count.
- Setup a Flat File Source.
- Use Row Count component to count rows.
- Use Conditional Split on row_count == 1.
- Use Script Component to capture row data into variables.
精彩评论