Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scamper
Yak Posting Veteran
52 Posts |
 Posted - 2012-05-21 : 12:15:13
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 16:55:13
|
| 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 thoughError 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
scamper
Yak Posting Veteran
52 Posts |
Posted - 2012-05-22 : 10:17:07
|
| 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