August 5, 2008 at 12:24 pm
I wanted to be able to import Excel files to a generic working table, then use stored procedures to manipulate the data. I have a generic raw table with 60 columns, all varchar. I wanted to be able to have the SSIS package simply take the data from the Excel file and migrate into the raw table. I have a configuration file where I can pass in the directory of the file, along with the name of the worksheet to use.
I am using an Excel Source, Data Conversion, and OLE DB Destination object in the Data Flow. I have this embedded in a ForEachLoop as there can be several files in the directory.
Currently I get a series of errors when trying to automate, and what I find by trying a web search is not much help.
Thanks in advance
JJ
August 5, 2008 at 12:27 pm
It sounds like you could make this work. Without knowing what the errors are it is hard to suggest any solutions though.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 5, 2008 at 12:33 pm
I do get some validation warnings. "Validation warning. XLS to Raw Table: Data Conversion: The component has inconsistent metadata"
The only thing I can think is that in my data conversion I mapped for up to 60 columns. None of the Excel files will have this many (so they tell me). Some of the columns also have NULL as the value in the first row. These NULL columns seem to be the numbered errors.
Did I miss something in my conversion step? When I look at the Excel Source, I am able to preview the data set correctly, but those NULL values are in there.
Thanks so much for the assistance!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply