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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2012-07-10 : 07:14:04
|
| i have ssis packge that loading 3 excel files.after i loaded the excel files,i delete it.i run this packge by job.if i do not have one of files, the job is failed, so how can i igonre this faile? |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-07-10 : 09:53:15
|
| are you using literal file names or dynamic in a loop<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2012-07-10 : 11:20:30
|
| it is dynamic file name in one container (no loop) |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-07-10 : 12:28:59
|
| print screen and paste here please to see what you are doing<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-10 : 12:50:29
|
| set ignore failure as onerror action for the task and set failpackageonfailure property of package to false and also link oncompletion precedence constraint to next task from task where you wanted to ignore failure.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-10 : 13:50:22
|
| I would make this 3 packages - or 1 package called 3 times.Then you can let the package fail if yoou like and ignore the error.Also means it's easy to rerun for a file and easy to see which file is missing.You might also think about building a scheduler so you can poll for the files and have dependent processes on the file loads - would have the file polling seperate from the processing as inhttp://www.nigelrivett.net/Products/DWBuilder/Scheduler_PollingForFiles.htmlhttp://www.nigelrivett.net/Products/DWBuilder/DWBuilder.html==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-07-10 : 16:52:24
|
| check for existence of file before deleting it or any other action you want to take<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2012-07-11 : 08:41:51
|
| i have a sequence container that contain 3 Data Folw Taskwhich loading 3 excel files.Data Folw Task-A :Excel File A (Excel Source-ole db Destination)Data Folw Task-B :Excel File BData Folw Task-C :Excel File Cevery day i run this packge by job. but if i do not have one excel file, the job is faile (even that i succes to load two other)i change the propeties of the pacjage- the package is not faile.what can i do , to make the job finish in success? |
|
|
|
|
|
|
error in job