Brandie Tarvin (1/25/2008)
Why are you using SQL to delete from an Excel spreadsheet? What are you trying to accomplish?
I have to import data from an excel file. First 10 rows of the excel file are just random description of client that I don't need. I tried to import all the data in one table, but it gives metadata mismatch error. It also tries to tuncate the data. I think what SSIS does is it looks at first couple of rows in excel and tries to determine data type, and it ends up deciding on the wrong ones.
The only way I was able to run the package is manually deleting first 10 rows of the table. But I have to automate it. Every month someone else will run the package once I create it. Let me know if you have any other ideas?
Take a look at pictures. It'll give you more idea what i'm talking about. One screen shot is the error and other one is actual excel file.