"Insert" uniqueidentifier

  • I try to run a very simple script in my DTS and there is an uniqueidentifier, here is a script

    "Function Main()

    User2 = DTSSource("ACCOUNT_ID")

    If (User2 = "0013393") then

     DTSDestination("USER_ID") = DTSSource("ACCOUNT_ID")

     DTSDestination("USERNAME") = DTSSource("USERNAME")

     DTSDestination("PASSWORD") = DTSSource("PASSWORD")

     DTSDestination("FIRST_NAME") = DTSSource("FIRST")

     DTSDestination("LAST_NAME") = DTSSource("LAST")

     DTSDestination("EMAIL") = DTSSource("EMAIL")

     DTSDestination("ACCOUNT_TYPE") = DTSSource("Account_Type")

     DTSDestination("ACCOUNT_RIGHTS") = DTSSource("Account_Right")

     DTSDestination("ACCOUNT_STATUS") = DTSSource("Account-Status")

    Main = DTSTransformStat_OK

    Else

    Main = DTSTransformStat_SkipRow

    End If

    End Function

    "

    the error message said that i try to insert a Null value or  data to a collum name "PERSON_ID" with the data type "uniqueidentifier"

     

    Is there a  vb script command that will generate a new value of type uniqueidentifier?

  • Hi

     

    As far as I know no…But its sounds like you need to import your data into a staging table to clean out the data first.

     

    Mike

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply