imani_technology (4/19/2011)
I corrected the SQL syntax so now it works.SELECT [POS Report-XXXX BRANDS-YYYYYYYY$].*
FROM [POS Report-XXXX BRANDS-YYYYYYYY$]
Ah, apparently the table needs to be aliased. Strange...
But my advise still stands: drop the * and use the real columns.
If someone types into a non-used column and then deletes the data, SSIS will still think there is a new column and it will add the column to the dataflow, resulting in a package failure.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP