June 22, 2006 at 7:15 am
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?
June 23, 2006 at 5:01 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply