Home Forums Data Warehousing Integration Services Conversion failed when converting from a character string to uniqueidentifier RE: Conversion failed when converting from a character string to uniqueidentifier

  • HI

    we found that the MID have lost its value somewhere and was null in the store procedure. This does not make sense as the rest of the information returned in the same select [from one talbe] is there (also passed to the store procedure to check that the select did work)

    we have enough info passed to the store procedure to enable us to now get the GUID in the store procedure in the event that it is empty