Post reply

Testing SSIS package

  • January 2, 2011 at 4:02 pm

    #148037

    Hello,

    Can anyone tell me step-by-step as how to test a SSIS package? I have already created the package. I need to test it now before putting it on the server.

    Can anyone help me with this?

    Thanks,

    Anup

  • January 2, 2011 at 11:04 pm

    #1268371

    I too am searching how to test a SSIS package and what parameters need to be considered while testing SSIS package.

    I got few answers which i mentioned below,but that really didnt solve my problem.

    1 Verify all the tables have been imported.

    2 Verify all the rows in each table have been imported.

    3 Verify all the columns specified in source query for each table have been imported

    4 Verify all the data has been received without any truncation for each column.

    5 Verify the schema at source and destination

    6 Verify the time taken /speed for data transfer

    7 Fields truncated due to difference in length of the field at destination.

    Can someone help showing how to test an SSIS package with some examples

  • January 3, 2011 at 3:49 am

    #1268397

    This might be an oversimplification, but I usually test SSIS packages by running them in BIDS and see if everything becomes green 🙂

    After that, I check if the output is the one I desire it to be (this entails most of the bullet points listed by vishnubhotla.uday). I do this usually with a small subset of the data.

    If the package runs too long, I'll try to optimize it.

    For some packages, for example those who import Excel files, I deliberately insert some errors in the excel file to see what the packages does and to see if event handlers work correctly.

    Furthermore I check if everything is logged correctly.

    Then I deploy the package to a test serverm,so I can see if it still runs when the environment has changed (this is a check for package configurations).

    If you have conditional logic in your package, you should try to execute all branches of the control flow.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 3, 2011 at 6:36 am

    #1268447

    I often test the steps by running them one at a time. In the BIDS environment, simply right click and choose Execute Task. If something goes wrong, I look at the progress tab to see what the issue might be.

    If I want to test several steps, I'll disable all the ones I'm not testing and then hit run.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply