umas (8/21/2009)
I have to check for the value "Credit" in the DocumentType column (destination table) and if it is found, I should map it to the DocumentNo column in the source table. I am not sure if I have to use a Destination Script Component and would like to know how this component would connect to the OLEDB destination table.
-are you trying to replace "CREDIT" with DocumentNo in the destination? Is the destination DocumentNo the same as source DocumentNo? (from your attachment)
I have the following script below used in the DTS.
Function Main()
DTSDestination("DocumentType") = "CREDIT"
Main = DTSTransformStat_OK
End Function
-I didn't have to deal with DTS much, but this looks to me like the package is setting DTSDestination("DocumentType") to "credit".
have you ever considered using the functionality ssis offers instead of trying to convert the package 1-to-1?