swathi chinni
asked on
How to load multiple sheets of an Excel File in SSIS with header information in the sheets
Hi,
I have a file with 2 sheets in it. It has the header information in it. I tried foreach loop container to load the data
Error i got is:
[SSIS.Pipeline] Error: "Excel Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
I tried removing the header row manually from the sheets and ran foreach loop container and it worked perfectly fine.
But in my requirement i will be getting the header row in each sheet.
How do i do in this case.
Attaching my sample file
Your help is much appreciated.
Thank you,
swathi
2017-MULTIPLESHEETS-TESTING.xlsx
I have a file with 2 sheets in it. It has the header information in it. I tried foreach loop container to load the data
Error i got is:
[SSIS.Pipeline] Error: "Excel Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
I tried removing the header row manually from the sheets and ran foreach loop container and it worked perfectly fine.
But in my requirement i will be getting the header row in each sheet.
How do i do in this case.
Attaching my sample file
Your help is much appreciated.
Thank you,
swathi
2017-MULTIPLESHEETS-TESTING.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Spreading the wealth around barring any other feedback. imo this is not a good road to go down in the first place.
ASKER
Thanks for the quick response . I am not sure how to write the script task code. Can you please help me with send the code that need to be in script task.
Thank you.