I have a SSIS package in which I am using Flat file destination. I need to pass the Column Delimiter and Row Delimiter using variable. I have used a variable for the RowDelimiter property of Flat File Connection Manager using SSIS expression.
But I dont know why it is not picking up the value from the variable. It is alway picking up the value which is defined in the Flat File Connection Manager editor and not from the variables.
For the Column Delimiter I am not even able to find a place to set the value for this.
Is it due to bug or I am missing something over here ? Any help would be highly appreciated.
View Complete Post