var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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:
DTSDestination("F6") = DTSSource(6)
Main = DTSTransformStat_OK
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.
There is nothing wrong with your syntax. But note that DTSDestination and DTSSource collections are 1 based. Try DTSSource(7)