"Insert" uniqueidentifier

• khanh truong-341643

  Grasshopper

  Points: 13

  More actions

  June 22, 2006 at 7:15 am

  #67556

  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?

• Michael Tocik

  SSCertifiable

  Points: 7099

  More actions

  June 23, 2006 at 5:01 am

  #645486

  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