Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Question Unanswered: 'Invalid procedure call' error when using 'DTSSource'

    I have a very simple transformation that's returning the following error:

    The number of failing rows exceeds the maximum specified.
    Error code: 0
    Error Source = Microsoft VBScript runtime error
    Error Description: Invalid procedure call or argument: 'DTSSource'

    Error on Line 6

    And I use the following code:

    Function Main()
    DTSDestination("F6") = DTSSource(6)
    Main = DTSTransformStat_OK
    End Function

    I've also tried DTSDestination("F6") = DTSSource(6).Value and DTSDestination("F6") = DTSSource.Item(6) and
    DTSDestination("F6") = DTSSource.Item(6).Value and they all return the same error.

    The only code that works is DTSDestination("F6") = DTSSource("Feb")
    "Feb" is the column 6 when using 0 based ordinal. I want to use ordinals because column 6 name changes every month.

    Any suggestions??

  2. #2
    Join Date
    Jan 2003
    British Columbia
    There is nothing wrong with your syntax. But note that DTSDestination and DTSSource collections are 1 based. Try DTSSource(7)

Posting Permissions

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