Passing GUID parameters

I'm building an integration where I want to pass a parameter (GUID) from a message to a dts. I have created an dts with a prompted variable (let say varx). The parameters I add to the integration process are the following:
/Vvarx=%XPath=//nameoflabelinmessage

The message contains this section:
{4E1A3462-A8DA-DE11-88B8-005056AE5887}

But when I run the DTS I get this error:
Source: Scribe.Exception: Fetch failed: An exception System.FormatException was thrown while trying to convert input value '#ERROR!' to attribute 'fieldname'. Expected type of attribute value: System.Guid. Exception raised: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

Anyone now what is causing this problem and how we can pass the parameters?

When I open the DTS and enter the GUID in the messagebox of the prompted variable the dts is working correctly.

Posted by Bas v. on Dec 9 2009 10:31PM { U438 , F9 , T1021 , C2938 }

(3) Answers

Login