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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy