Post reply

SSIS to load different format of excel file to SQL table

  • November 30, 2014 at 12:53 pm

    #397709

    Hello I am new to SSIS. I would like to find a way to load 3 different excel file to 3 different SQL tables.

    Thanks for sharing an example,

    Stanley

  • December 1, 2014 at 12:59 am

    #1761613

    Moving Data From Excel to SQL Server - 10 Steps to Follow[/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 1, 2014 at 5:17 am

    #1761663

    Yes my question is how can I import 3 excel file with different structure, to 3 different sql table with SSIS?

    Thanks,

  • December 1, 2014 at 5:25 am

    #1761665

    You read the article and follow the steps three times in a row.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 1, 2014 at 6:13 am

    #1761681

    Usually I post my question her. If that's not the right place to do it can you please let me know??

    Thanks,

  • December 1, 2014 at 6:21 am

    #1761682

    Stanley Pagenel (12/1/2014)

    Usually I post my question her. If that's not the right place to do it can you please let me know??

    Thanks,

    It's the right place.

    The article I linked to should explain how you can load an Excel file with SSIS to a database table.

    Since SSIS cannot change metadata dynamically in the data flow, you'll have to create either 3 different packages or 1 big package with 3 different data flows.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 1, 2014 at 6:24 am

    #1761683

    Sorry about that I didn't not see the article at the beginning, and that's why I was kept replying back to you.

    Thanks a lot and have a nice day,

    Stanley

  • December 1, 2014 at 6:27 am

    #1761685

    Stanley Pagenel (12/1/2014)

    Sorry about that I didn't not see the article at the beginning, and that's why I was kept replying back to you.

    Thanks a lot and have a nice day,

    Stanley

    Ah yes, it's a URL 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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