In SQL Server Integration Services (SSIS), you have to option to Redirect records that can't…
Here is a very cryptic error message which managed to puzzle me a bit: “The package failed to load due to error 0xC0010014 “One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.”. This occurs when CPackage::LoadFromXML fails.” This happens when you try to schedule an SQL Agent job on SQL Server 2005 and as one of the steps you specify a SSIS package which is developed in SSIS 2008.
Well, it is very unpleasant and makes me think:
1. Apparently the forward compatibility between SQL Server editions is nonexistent
2. Who gains what from this fact
3. What would have happened if MS Office 2003 was unable to open MS Office 2007 documents. (Hehe, a rebellion in the corporate world, maybe?! 🙂 )
I will not comment further on this, except I would like to mention that it just makes me bitter sometimes when I think how many obstacles are laid down the road of perfection. (Well, the SQL Server perfection, that is). Yet another fact that has been circling in my head for a while now: think about the partial failure of the Resource Governor, for example. Not only is it pricey (available only in the Enterprise edition!), but it is also only half-useful. Why? Well, the bottleneck candidate #1 is the I/O system, right? However the Resource Governor governs only the CPU and the memory, eh? Think about it.