Hi,
When i m trying to execute the following function i m getting
Error Message is Invalid Procedure Call or arguement DTSSource
'************************************************* *********************
' Visual Basic Transformation Script
'************************************************* ***********************
' Copy each source column to the destination column
Function Main()
DTSDestination("acct_id") = DTSSource("Account_ID")
DTSDestination("acct_nm") = DTSSource("Account_Name")
DTSDestination("acct_type") = 1
DTSDestination("acct_sts") = DTSSource("Enabled")
Main = DTSTransformStat_OK
End Function
thnks in advanceis DTSDestination("acct_type") of type integer,numeric or decimal?
if not, I think you have to add double quotes around the "1". Hope it helps :)
Sunday, February 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment