Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: String Length in DTS

    Hi

    I am quite new in DTS and I want to calculate the length of a string. I am trying to use ActiveX script - Java Script and here is my code

    if(length(DTSSource("MaNo")) ==5). It parse fine but when I run a test it brings an error "Error Description: Object Expected"

    Please help

  2. #2
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201
    I think syntax is wrong

    if LEN((DTSSource("MaNo")) =5) then

  3. #3
    Join Date
    Jun 2006
    Posts
    2
    Hi

    The formula returns correct length but the if statements execute no matter what length. What could be the cause?

Posting Permissions

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