Post reply

RowsComplete property in Transfor Data Task in DTS

  • January 23, 2008 at 10:30 pm

    #119723

    I need to get the value of RowsComplete property in Transform Data Task. I use the following code,

    [font="Courier New"]Set pkg = DTSGlobalVariables.Parent

    lngRowsComplete = pkg.Tasks("04: Transfer Data from ODS to DCSA").RowsComplete[/font]

    But I get following error message when I execute the package,

    [font="Courier New"]Object doesn't support this property or method : 'pkg.Tasks(...).RowsComplete[/font]

    Is there any other way to solve this problem?

    - Zahran -

  • January 23, 2008 at 11:50 pm

    #771159

    I found it. 🙂

    The correct code is,

    [font="Courier New"]pkg.Tasks("04: Transfer Data from ODS to DCSA").Properties("RowsComplete").Value[/font]

    - Zahran -

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

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