Results 1 to 7 of 7

Thread: SSIS Packages

  1. #1
    Join Date
    Oct 2011
    Posts
    3

    Unanswered: SSIS Packages

    Hello,
    I have a SSIS package and I am dumping data everyday from one database to another using that SSIS package.
    After few days, The database is out of space and data is not importing to that table using SSIS package. SSIS package is not throwing any error.

    May I know, why SSIS package is not throwing error. ?

    TIA

  2. #2
    Join Date
    Sep 2011
    Posts
    71
    hello ramll ,i post you some important notes may help you to detect your problem ,So let me know the results
    To handle errors that may occur in the transformation process, Microsoft Integration Services gives you the ability to decide on a per component and per column basis how to handle data that cannot be transformed. You can choose to ignore a failure in certain columns, redirect the entire failed row, or just fail the component. By default, all components in Integration Services are configured to fail when errors occur. Failing a component, in turn, causes the package to fail and all subsequent processing to stop.

    Instead of letting failures stop package execution, it is good practice to configure and handle potential processing errors as they occur within the transformation. While you might choose to ignore failures to ensure your package runs successfully, it is often better to redirect the failed row to another processing path where the data and the error can be persisted, examined and reprocessed at a later time.

    In this lesson, you will create a copy of the package that you developed in Lesson 4: Adding Logging. Working with this new package, you will create a corrupted version of one of the sample data files. The corrupted file will force a processing error to occur when you run the package.

    To handle the error data, you will add and configure a Flat File destination that will write any rows that fail to locate a lookup value in the Lookup Currency Key transformation to a file.

    Before the error data is written to the file, you will include a Script component that uses script to get error descriptions. You will then reconfigure the Lookup Currency Key transformation to redirect any data that could not be processed to the Script transformation.
    see below link for further details thanks
    Lesson 5: Adding Error Flow Redirection

  3. #3
    Join Date
    Oct 2011
    Posts
    3
    I am not getting error. That is my issue.

    SSIS package is importing data and there is no space in that table.

  4. #4
    Join Date
    Sep 2011
    Posts
    71
    Hello ramll ,I knew that ? But your last question was?

    May I know, why SSIS package is not throwing error. ?
    So my answer was
    you should Confiqure SSSIS Package to show an error if any ,that's what i meant

  5. #5
    Join Date
    Oct 2011
    Posts
    3
    Quote Originally Posted by paultech View Post
    Hello ramll ,I knew that ? But your last question was?


    So my answer was
    How and where to configure ?

    Thanks for your patience

  6. #6
    Join Date
    Sep 2011
    Posts
    71
    Ok ,listen to me
    you will create a copy of the package that you developed , Working with this new package, you will create a corrupted version of one of the sample data files. The corrupted file will force a processing error to occur when you run the package.
    To handle the error data, you will add and configure a Flat File destination that will write any rows that fail to locate a lookup value in the Lookup Currency Key transformation to a file.
    Before the error data is written to the file, you will include a Script component that uses script to get error descriptions. You will then reconfigure the Lookup Currency Key transformation to redirect any data that could not be processed to the Script transformation ,Practically=>
    You can include the error description in the text file using this simple technique:
    Rushabh Mehta : Gracefully Handing Task Error in SSIS Package
    SSIS Junkie : SSIS Nugget: Get error descriptions
    Error Handling in SSIS - SQLServerCentral

  7. #7
    Join Date
    Sep 2011
    Posts
    71

    Question sssis package error handeling

    Ok ,listen to me
    you will create a copy of the package that you developed , Working with this new package, you will create a corrupted version of one of the sample data files. The corrupted file will force a processing error to occur when you run the package.
    To handle the error data, you will add and configure a Flat File destination that will write any rows that fail to locate a lookup value in the Lookup Currency Key transformation to a file.
    Before the error data is written to the file, you will include a Script component that uses script to get error descriptions. You will then reconfigure the Lookup Currency Key transformation to redirect any data that could not be processed to the Script transformation ,Practically=>
    You can include the error description in the text file using this simple technique:
    Rushabh Mehta : Gracefully Handing Task Error in SSIS Package
    SSIS Junkie : SSIS Nugget: Get error descriptions
    Error Handling in SSIS - SQLServerCentral

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •