DTS/Transformation rowguid | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS/Transformation rowguid

Haven’t used the rowguid column before so sorry if this is a simple question.
I’m building a DTS Transform package … here is my transform DTSDestination("accountManagerId") = "1"
DTSDestination("clientId") = "2"
DTSDestination("clientName") = DTSSource("Col002")
DTSDestination("clientType") = "Account"
DTSDestination("creditStatus") = "Approved"
DTSDestination("dateFirstProject") = Null
DTSDestination("defaultInvoiceTerms") = "net 15 days"
DTSDestination("description") = ""
DTSDestination("estAnnualRevenue") = 0
DTSDestination("inactive") = "0"
DTSDestination("industryType") = " "
DTSDestination("naicsCode") = " "
DTSDestination("notes") = " "
DTSDestination("numberOfEmployees") = " "
DTSDestination("numberOfLocations") = 1
DTSDestination("parentCompanyId") = 0
DTSDestination{‘rowguid’]= ?????????????????
DTSDestination("totalSales") = 0
DTSDestination("website") = " " It’s the DTSDestination{‘rowguid’]= that continues to blow. I’ve tried everything I
can think of :-(. The table column is rowguid with default newid(). Thanks for your help.
Teresa
Leave the column out the transform. It should be able to insert a value automatically using the NEWID() default. Or you could force a value into the column by entering a GUID e.g "{12345678-ABCD-EF34-1234-123456789011}". I wouldn’t recommend this. This GUIDs are meant to be ‘automagically’ generated by SQL server and used (mostly) internally. Nathan H.O.
Moderator
SQL-Server-Performance.com
Hello!
First : Sorry for my poor english.
Second :I have the same problem : execpt :
If i leave the column out the transform the rowguid make me an alert because it must be not null… Il i try newid() it make me an error to… Do you have a solution for this ?
Thx
Pierre

]]>