shafirmubarak (4/15/2014)
I tired -- User == "" ? "" : (DT_GUID)("{" + User + "}")
What is "User" in your expression?
Regarding the empty GUIDS, what is the exact error that you get?
Try setting the property "Retain null values from the source as null values in the data flow" to true in the flat file source.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP