SQL Server Performance

DTS/Transformation rowguid

Discussion in 'SQL Server DTS-Related Questions' started by teresac, Jul 2, 2004.

  1. teresac New Member

    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
  2. vbkenya New Member

    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
  3. thegritch New Member

    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

Share This Page