SSIS - variable for specific character within the data?
Posted on 2012-03-22
I need to evaluate a collection of files based on a specific character in the data. Specifically, it will be located in row 1, character # 104.
When that character is shown, it identifies the delimiter for the file and then I would like to create a task to replace all of the first characters in the file with the second (so that I don't have to create multiple workflows, rather I can have one workflow and just adjust the incoming files to work with it).
I was thinking on using a script task with a precedence constraint that would have an expression that utilizes a variable based on the "found" delimiter character.