Post reply

SQL Server 2008 - Loading multi Tab Excel 2008 spreadsheets into same table

  • July 21, 2010 at 7:50 am

    #227099

    Need help on Loading multi Tab Excel 2008 spreadsheets in same table using

    SQL Server Integration Services with SS2008.

    All spreadsheets have the same structure.

    Thanks,

    Jeff


    jcollins

  • July 21, 2010 at 8:04 am

    #1196170

    Are the names of the tabs known in advance? If so, use a For or ForEach container to loop through each tab. Inside that, put the name of the tab in a variable, and use that variable in the Excel Source as the tab name.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 1 (of 1 total)

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