March 13, 2015 at 10:24 am
I am building a generic SSIS where it takes a text source file and converts to a destination source file . However in the process I want to set the row delimiter and the column delimiter dynamically through the package variable. So that I can use it for any file transfer.
I saw the option for row delimiter in the file connection string property but did not see any column delimiter option.
Any help would be greatly appreciated.
March 13, 2015 at 11:16 am
In SSIS, the column delimiter is actually per column, which is why you don't see a property for it.
Gerald Britton, Pluralsight courses
March 13, 2015 at 1:35 pm
So I do I get around it any idea?
March 16, 2015 at 12:58 pm
Use a script component for the source and pass in the variable containing the delimiter
Gerald Britton, Pluralsight courses
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply