February 25, 2009 at 9:43 am
I am having troubles figuring out why I am having a problem.
The below three work:
Function Main()
DTSDestination("Value") = DTSSource("Price")
Main = DTSTransformStat_OK
End Function
Function Main()
DTSDestination("Value") = DTSSource("Shares_Outstanding")
Main = DTSTransformStat_OK
End Function
Function Main()
DTSDestination("Value") = DTSSource("Shares_Outstanding") * DTSSource("Shares_Outstanding")
Main = DTSTransformStat_OK
End Function
And if I do Price times Price it works too.
So why does this never work?
Function Main()
DTSDestination("Value") = DTSSource("Shares_Outstanding") * DTSSource("Price")
Main = DTSTransformStat_OK
End Function
The error I get is:
Error Source : Microsoft Data Transformation Services (DTS) Data Pump
Error Description : 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
I have one record in the file I am testing right now and even made both columns have a number with a decimal in it and it still didn't fix the problem.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
February 25, 2009 at 10:44 am
I hate when problems are so simple I can't figure them out. I just figured out the problem. I needed to include both columns in the Source Columns tab. So now it works.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply