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 |
|
theboyholty
Posting Yak Master
226 Posts |
 Posted - 2013-02-08 : 11:18:03
|
| I'm doing an import of around 1300 excel files. I can get it to work but occasionally a spreadsheet will not have been formed properly. My SSIS package looks for the worksheet called 'YieldData', but one or two have the default worksheets called Sheet1, Sheet2, Sheet3. As it happens, these excel files are blank so what I'd like to do is ignore these altogether. Is it possible to set up my SSIS package so it ignores files that would otherwise cause the package to fail, and to carry on with the rest regardless?---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-08 : 11:33:08
|
| yes...its possible. make the onerror action to ignore failure inside data flow task.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2013-02-19 : 04:42:27
|
| Thanks. Where do I set that property?By default, the FailPackageOnFailure and FailParentOnFailure are set to False and I can't find an onerror property.btw, I'm using SSIS 2008.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-19 : 05:13:24
|
quote:
Originally posted by theboyholty
Thanks. Where do I set that property?By default, the FailPackageOnFailure and FailParentOnFailure are set to False and I can't find an onerror property.btw, I'm using SSIS 2008.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum
thats inside the properties window of data flow task excel source------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
multiple excel import - files inconsistent