Just a quick note about an error that stumped me for a minute.
I was setting up a Lookup task in SSIS 2005 using the results of a SQL query as the lookup, but I kept getting the following error when attempting to create the column mappings:
TITLE: Microsoft Visual Studio
------------------------------
Error at Load Position Limit Data [Lookup [49]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF.
Error at Load Position Limit Data [Lookup [49]]: The call to Lookup transform method, ReinitializeMetadata, failed.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02090F0 (Microsoft.SqlServer.DTSPipelineWrap)
This didn't seem like a very helpful error, until I thought about what ReinitializeMetadata probably did, and then realized that my query selected a sql_variant column without casting it. Casting the sql_variant to a more appropriate data type (varchar, in this case) resolved the error.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment