ssis 2008 r2 problem on sql server

  • I am wondering if sql server 2008 r2 integration services can accomplish the following task(s) and/or at least part of the following tasks?

    My company recieves an excel woorkbook 2003 from our customer daily. The data that needs to be loaded to the sql server database is always on the 6th tab in the workbook. The problem is sometimes there are links to other parts of the spreadsheet we do not have access to when we receive the file. Also some of the columns and/or rows may be hidden.

    I know my company will not ask the customer to change the way we receive the data. We need to just take the data the way we receive it.

    Thus can you tell me what task(s) SSIS can complete and where I need to place error handling logic to account for the tasks SSIS can not complete?

    Also, can you point me to a reference how to setup error handling in SSIS?

  • Do the links give any problems when you try to read the sheet with SSIS?

    Hidden rows/columns shouldn't give a problem.

    Error handling:

    Debugging and Error Handling with SSIS Packages

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

  • If the hidden columns/rows cause a problem, what do you think I should do to solve the problem?

  • Write a SQL query to the Excel file instead of just selecting it in the dropdown menu.

    The sheet represents the table in the FROM clause of the SELECT query. There you can specify a range, and that will ignore the fact if something is hidden or not.

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

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

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