I have a simple SSIS package that does the following.ÃÂ
On the control flow tab, there is an Execute SQL task that calls a stored procedure and returns a GUID.ÃÂ
I have a package scoped variable that stores a UNIQUEIDENTIFIER output from the stored procedure. It appears that the package variable data type does not include a GUID data type so I tried to use string instead.
Next, the Execute SQL task is mapped to a data flow task.ÃÂ
Within that data flow task I have an OLE DB Source which connects to a SQL Server Destination task.
On the OLE DB Source Editor screen I have a query that performs the following:
SELECT ID, SessionKey, ....
WHERE SessionKey = ?
I have clicked on the parameters button to map the Parameter to my variable called User::SessionKey. This is the output variable from my Execute SQL Task component on the Control Flow tab. This value should be a GUID, but again, I don't see a data type for that.
When I execute the package it fails on the OLE DB Source with the following error:
[OLE DB Source ] Error: SSIS Error Code DTS_E_OLEDBERROR. ÃÂ An OLE D
View Complete Post