Hi:
When I import data from multiple excel files, the Excel source gives validation errors if the case of a column name changes.
How can I make my excel source Case Insensitive?
TIA
Kar
I don't know of any way to do this, but it should be possible to "pre-process" the Excel spreadsheet to LOWER() the column names before running the data flow by using the Script task and the Excel object model.|||Well, I could do that, but I hoped there was an extended property or something to set the Engine to Case-insensitive mode.
Anyways, I have a workaround. Use a SQL Query or a SQL Query from variable, and the case that you have in the query will hold for the rest of the dataflow, no matter what the source excel contains in its first row.
Thanx
Kar
|||If there is, I'm unaware of it. I'll bow out and we can see what others have to say. Good luck!
No comments:
Post a Comment