robert.gerald.taylor (8/20/2013)
Donny Z (8/19/2013)
Jeff Moden (10/16/2011)
The way I solved this problem for my group was to simply use QUOTENAME(columnname, '"') and make sure that I used '"' as the text qualifier.Can anyone explain more about this??
This kind of statement is like "I know how, but I won't tell." kinda statement.
Take a look at: http://technet.microsoft.com/en-us/library/ms176114(v=sql.105).aspx
A simple search brought that back. :rolleyes:
HTH,
Rob
Hi Rob,
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.
--------------------------------------
I already spent few days looking for answer like this for SSIS 2008 (yup, the saga continues to 2008) and bcoz it's driver caused problem, I'm stuck w/ converting the excel to other delimited format file then use SSIS to read the result file. Still trying to find free converter which can be executed through CMD prompt though :pinch: