I have trouble getting rid of the curly brackets on the uniqueidentifier value. The destination is a csv flat file.
I tried something like this,
select substring(CONVERT(varchar(36), my_GUID), 2, 36) ...
but it complained that
Msg 8169, Level 16, State 2, Line 9
Conversion failed when converting from a character string to uniqueidentifier.
select CONVERT(varchar(36), my_GUID) ...
but the brackets are still there.
Of cause, the select in SSMS did not return curly brackets, but the SSIS out did.
What is the trick?