Hi All, I'm using webservice task in ssis 2008. If package fails then I need to capture eventId of that error into a ssis variable . How to do this using ssis, plz its very urgent Thanks, RHsql

You want to configure logging within SSIS and log the errors to a provider. You can choose to log to the windows event log, a flat file, or a table. I'd recommend BI xPress from Pragmatic Works. It is very easy to configure logging for a bunch of packages all at once. The trial version lets you apply logging to 5 packages so you've got nothing to lose.Michael R. Milligan, MS DIS Senior Consultant - Pragmatic Works Consulting Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | <a href="http://pragmaticworks.com/services/Cons

I dont know about event id but you can capture error code or package Id etc using a variable. Add ssis variable->go to propertied-> set evaluateasexpression to 'true' and in expression builder you can use system variables to get the value ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

You want to configure logging within SSIS and log the errors to a provider. You can choose to log to the windows event log, a flat file, or a table. I'd recommend BI xPress from Pragmatic Works. It is very easy to configure logging for a bunch of packages all at once. The trial version lets you apply logging to 5 packages so you've got nothing to lose.Michael R. Milligan, MS DIS Senior Consultant - Pragmatic Works Consulting Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | <a href="http://pragmaticworks.com/services/Cons

You want to configure logging within SSIS and log the errors to a provider. You can choose to log to the windows event log, a flat file, or a table. I'd recommend BI xPress from Pragmatic Works. It is very easy to configure logging for a bunch of packages all at once. The trial version lets you apply logging to 5 packages so you've got nothing to lose.Michael R. Milligan, MS DIS Senior Consultant - Pragmatic Works Consulting Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | <a href="http://pragmaticworks.com/services/Cons

I dont know about event id but you can capture error code or package Id etc using a variable. Add ssis variable->go to propertied-> set evaluateasexpression to 'true' and in expression builder you can use system variables to get the value ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

I dont know about event id but you can capture error code or package Id etc using a variable. Add ssis variable->go to propertied-> set evaluateasexpression to 'true' and in expression builder you can use system variables to get the value ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you