May 21, 2012 at 10:17 am
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?
May 21, 2012 at 11:41 pm
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
May 22, 2012 at 8:19 am
If the hidden columns/rows cause a problem, what do you think I should do to solve the problem?
May 22, 2012 at 1:38 pm
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