Post reply

DTS Sucess/Failure

  • February 7, 2008 at 5:23 am

    #178895

    Are there definitions out there somewhere of what constitues Success or Failure of a task within DTS?

    For instance (I have many more questions which hopefully I can find the answer to myself if pointed in the right direction) -

    I have TRansform Data Task - which moved records from A to B

    If it finds not records to move - Is this failure (even though its moved everything it should have done - ie NO Records)

    Thanks

  • February 12, 2008 at 8:22 pm

    #777662

    would need to know more about what the dts task is doing to answer. but books online is a great place to start.

  • February 13, 2008 at 3:04 am

    #777727

    Thanks - from above - say this was just a simple one table TRansform Data Task - which moved records from A to B

    If it finds no records to move - Is this failure (even though its moved everything it should have done - ie NO Records)

  • February 13, 2008 at 10:28 am

    #777949

    A task failure indicates an error. 0 rows selected in a Transform Data task isn't an error, so the task would succeed.

    As JDixon said, the Data Transformation Services section of BOL is a good source of info. http://www.sqldts.com/ also has a lot of good info.

    Greg

  • February 14, 2008 at 2:22 am

    #778239

    Thanks - I will have a look.

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

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