Donny Z (8/21/2013)
I know what QUOTENAME's function is.What I mean is how Jeff apply it in the excel source, cause AFAIK we can't use every T-SQL function when we try to select from excel, and we can't define text-qualifier unless we're using Flat File Source :ermm:
So I thought maybe Jeff got something up his sleeve or know something I don't.
And basically I asked the same question suslikovich asked before my post.
Sorry, I misunderstood where the unknown was.
Throwing together a Q&D test SSIS package, I see that the Jet engine squawks if you try to use the QUOTENAME() function in a SELECT against the Excel data source.
Rob