• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 826
  • Last Modified:

SSIS package : error handling

Hi,

I call a SSIS package from a C# application to transfer date from a SQL Server 2005 database to an oracle database.
I want to catch all errors in an oracle table. What can I do? in SSIS package or in Windows forms application?

My dtsx package contains a Data Flow Task. I try to define a container with a SQL task. Waht can I know in the C# application that there is or not one error?

Thanks for your help.

0
AngieWill
Asked:
AngieWill
  • 4
  • 2
3 Solutions
 
Reza RadCommented:
you can use precedence constraint after your dataflow task and connect it to a script task for example
then right click on precedence task and select type as failure
in this type you can catch the error and do appropriate actions, for example write a log in file, or send mail with send mail task or ...
0
 
Reza RadCommented:
you can also do this inside your data flow task to do appropriate action on any row in dataflow which has error on transfer operation
0
 
AngieWillAuthor Commented:
Thanks for your help.

Do you have perhaps a sample?

I try with  a sequence Container. I try to add a 'Execute SQL Task' for the OnError Event handler. Can work too?

What is the syntax for the SQLStatement?

Thanks
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
rajvjaCommented:
0
 
Reza RadCommented:
if you want to do a simple error handling just use on error event handler and add a script task there and do your appropriate action.
but if you want to do deeper consideration on exact error descriptions in dataflow tasks you can use some articles like below:
http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/62662/

and about syntax in sql statement, just use sql syntax which you used in your dbms,

I think if you want more deeper help, you must explain what you want to do exactly in this package.

Regards,
0
 
Reza RadCommented:
0
 
AngieWillAuthor Commented:
Thanks for your helps
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now