LTRIM(column1) == "" ? (DT_STR,100,1252)NULL(DT_STR,100,1252) : (column1) == "Y" ? (DT_STR,100,1252)1 : (DT_STR,100,1252)0
I finally arrived at the correct derived column expression.
Let me brief on this.
I am pulling the data from text file and dumping it into sql table.
So when loading column1 value from text file to sql table it should be loaded under BIT datatype.
So that why i have added the above expression to that column.
Hope this would help someone ....
Thanks for your reply. If i come across this kind of issue i will start a new thread.