Post reply

Bulk Excel Imports

  • November 16, 2011 at 4:12 am

    #246246

    Hi All,

    I want to import around 100+ excel files into SQl Server 2008R2, is there a simple way of doing this? or any way of doing?

    Thanks

  • November 16, 2011 at 4:14 am

    #1408352

    Same Structure?

  • November 16, 2011 at 4:20 am

    #1408354

    at the moment, through import data tool i can only import a file one by one but i would like to do all at once so i dont to do it 300 times

  • November 16, 2011 at 4:30 am

    #1408356

    If you know little bit of SSIS?

    Yes:

    1) Create one SSIS Package with Export Import Wizard.

    2) Modify it to loop through 300+ files.

    2) Execute Package & you are Done. 🙂

    No:

    Do the same with BULK INSERT or BCP with T-SQL. 🙁

  • November 16, 2011 at 4:37 am

    #1408357

    ok, i do know a lil SSIS but what flow items do i use?

  • November 16, 2011 at 4:46 am

    #1408362

    Do it step by step...

    First create a package with Export Import Wizard. It means, Open the wizard, Select source, destination etc. and save it as SSIS Package.

    Once done, open this package with BIDS. You will find a data flow inside. You just need to tweak it a bit to suit your requirements.

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

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