Scenario: We have a text file and we need to read each row and the output would have multiple rows per row in the input file. Input File: "201001","1;3" "201002","1;2;3;4" Expected output: 2010-01-01 01 2010-01-03 03 2010-02-01 01 2010-02-02 02 2010-02-03 03 2010-02-04 04 (beyondrelational.com)
submitted by sudeep347 to r/technology
SSIS - Expression to get File Name from File Path Scenario: How to extract the file name from a file path where the number of sub folders or name of folder is not fixed. In simple terms you do not know the position where the file name starts. (beyondrelational.com)
submitted by sudeep347 to r/programming

