Protean

A quick nugget… If you get this error:

[DTS.Pipeline] Error: component “OLE DB Source” (79) failed the pre-execute phase and returned error code 0xC0010001 

Check that your variables are mapped and that they can be read at run time. Similarly if you get the same error code with the description:

Configuration from a parent variable “XXXXX” did not occur because there was no parent variable. Error code: 0xC0010001.

Check that you have spelt and referenced the correct parent variable.

This entry was posted on Monday, January 14th, 2008 at 10:23 am and is filed under Nuggets, SSIS, Fixes, SQL Server 2005. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.