Post reply

Loads intermittent success in SSIS

  • February 10, 2009 at 5:09 am

    #197014

    Hi

    When I run my SSIS packages it runs with successfully completing, however when target database is checked it is empty. When the package is reran, it loads successfully and data may be found. has anyone come across such behavior.. Please help

  • February 10, 2009 at 7:10 am

    #941177

    Can you give some more information about your environment - what is the source of the data you're pulling? Are there any conditional splits, lookup transforms, etc., that could possibly be filtering the data?

    You can also add a data viewer to your pipeline by double clicking the connector and adding in a grid data viewer - this will allow you to see the data flowing through the process.

    hth,

    Tim

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

Viewing 2 posts - 1 through 2 (of 2 total)

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