Need Help!! Load in SSIS 2 large excel files with different structures(1 file has 5 less columns that others) on the Same table in sql server

Question

Need Help!! Load in SSIS 2 large excel files with different structures(1 file has 5 less columns that others) on the Same table in sql server

jkabirm

SSC Enthusiast

Points: 132
More actions
December 24, 2018 at 9:38 am

#416584

Hi Forum,
I am new here.
Please help me with loading 2 large excel files in ssis. Many tricks i applied. But I failed. I tried using foreach loop // 2 different DFT. Nothing works.
What I found, only 1 File I can dump in Sql server.
Thank you for your time.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 734489 More actions · Answer 1

You haven't provided any information here.
Don't use the title, but describe the problem and errors in detail, along with what "tricks" you have used. Otherwise we may end up suggesting the same things you've tried.

jkabirm SSC Enthusiast Points: 132 More actions · Answer 2

Steve Jones - SSC Editor - Monday, December 24, 2018 10:02 AM
You haven't provided any information here.
Don't use the title, but describe the problem and errors in detail, along with what "tricks" you have used. Otherwise we may end up suggesting the same things you've tried.

thank you for your reply.
what I did.
* each files size is 80MB.
1. foreach loop container
2. 2 DFT for each files
3. I can see only file records can be loaded.

sgmunson SSC Guru Points: 110639 More actions · Answer 3

jkabirm - Monday, December 24, 2018 10:08 AM
Steve Jones - SSC Editor - Monday, December 24, 2018 10:02 AM
You haven't provided any information here.
Don't use the title, but describe the problem and errors in detail, along with what "tricks" you have used. Otherwise we may end up suggesting the same things you've tried.
thank you for your reply.
what I did.
* each files size is 80MB.
1. foreach loop container
2. 2 DFT for each files
3. I can see only file records can be loaded.

What you just posted in steps 2 and 3 isn't at all helpful. You'd have to assume that DFT stands for Data Flow Task. Step 3 is meaningless gibberish. Clearly, there's a language translation issue here. As this is an English-based forum, you'll need to be a lot more specific. So many folks here are just not all that willing to help folks who aren't willing to demonstrate in specific detail, EXACTLY what they did, that you're going to have to change the way you think about getting help. Just asking for help begs too many questions. You need to be very specific about the details of each of the DFTs. And the table(s?) involved as well as the spreadsheets, and exactly how you set those up in your connection managers, and how it's all connected together in the package, at the absolute minimum. Be prepared to provide exact details on any errors you received, as well as what the actual results were, versus what the expected results were.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

mark_p Valued Member Points: 53 More actions · Answer 4

In your situation, I'd create two separate connections and load them both into the same destination table. You've got two different sources, so a loop may not work as well as expected. Excel files can be fiddly, especially at the size you're using.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

This is a duplicate post, more here: https://www.sqlservercentral.com/Forums/2014486/SSIS-Help

mark_p Valued Member Points: 53 More actions · Answer 6

Lynn Pettis - Friday, January 4, 2019 9:43 AM
This is a duplicate post, more here: https://www.sqlservercentral.com/Forums/2014486/SSIS-Help

Do you reckon they'll keep posting until they get an answer that they like then?