Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    10

    Cool Unanswered: Error in ActiveX script in DTS

    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 advance

  2. #2
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Re: Error in ActiveX script in DTS

    is 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
    Save the dugongs!

Posting Permissions

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