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?
You can make use of data flow task with excel source for it. SO far as tab is same you can give corresponding sheetname (i hope its same always) inside excel connection manager to only take data from it. Dont think so you'll be able to read from hidden columns though
Error handling can be done by means of event handlers in ssis. you've event handlers available for events like OnError where you can implement logic for error handling
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
If the data actually ends up being on a different tab, would I still be able to use 'data flow task'? Also can you give me directions on how to use the 'data flow task'?
ssis problem 2008 r2 sql server
Posted - 05/21/2012 : 12:15:13
