The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
in
Home SS SLUG Forums Articles Photos Downloads

Nuggets from My SSIS Experience

Last post 04-03-2008, 8:53 by Dinesh Priyankara. 2 replies.
Sort Posts: Previous
  • Nuggets from My SSIS Experience

     03-17-2008, 11:14

    • Joined on 11-22-2006
    • Colombo, Sri Lanka
    • Posts 102
    • Points 0
    • Top 10 Contributor
      Male
    This thread is for the article Nuggets from My SSIS Experience written by Dinesh Priyankara. Rate it and give your feedback.

    How would you rate this article?

    • Excellent (66.7%)
    • Good (33.3%)
    • Average (0%)
    • Fair (0%)
    • Poor (0%)
    • Total Votes: 3
  • Re: Nuggets from My SSIS Experience

     04-02-2008, 17:00

    • Joined on 04-02-2008
    • Posts 1
    • Points 0
    • Top 100 Contributor

    Hi Dinesh,

    It's good to see other people struggling to resolve the same issues in SSIS that I've had.

    In relation to your first point - handling the error and continuing execution - I've found that the best solution is to set the system variable [system::propagate] to false in the error handler. To put this into the context of your package, you would create an error handler for the "File Copy" task where you would raise your error message and perform your logging. In the properties of the error handler you set the "propagate" variable to false and you should find that execution will continue. What this does is prevent errors being passed up the container hierarchy. What you can even do is set the property of propagate to true for some errors and false for others giving you more control over what should stop execution and what shouldn't.

    Nice article by the way

    Regards

    Frank

  • Re: Nuggets from My SSIS Experience

     04-03-2008, 8:53

    • Joined on 11-22-2006
    • Colombo, Sri Lanka
    • Posts 102
    • Points 0
    • Top 10 Contributor
      Male

    Hi Frank,

    Thanks for the comment and thanks for the great point. I was unaware about system::Propagate usage, and it seems it can be used to solved many issues related to error handling. I will definitely try and see.

    Regards,

    Dinesh

     

View as RSS news feed in XML

(Best viewed with a resolution of more than 1024 * 768)

Powered by Community Server, by Telligent Systems