Thanks Yusuf, exactly right - was obviously having a syntax meltdown - fifth language this week! Ben

Thanks Todd. The consultant is not familiar with .Net technology, so a combination of yours and .netmans answers should give us a enough to make it a non-issue. Ben

LINQ for MySql, Postres, Oracle[^]

Bjohnson33 wrote: Seems most odd that that this isn't supported Yes this is what we call a 'bug' and microsoft calls a 'feature':laugh: What I tend to do nowadays is always pipe the results into a table then run the DTS from one table. This has a tendency to simplify things a lot as processes, including file copying etc, are visible within the stored procedure and not hidden within the DTS package (I avoid the DTS vb scripting feature as although it looks good - try debugging a DTS package with all that code hidden away in various places). You always pass failure on the way to success.

Ennis Ray Lynch, Jr. wrote: The xml serializer is very leniant. But not forgiving! Ever had to debug that lame generic XML serialization exceptions? You have to drill down into about 45 inner exceptions to get to the root of the cause :) xacc.ide The rule of three: "The first time you notice something that might repeat, don't generalize it. The second time the situation occurs, develop in a similar fashion -- possibly even copy/paste -- but don't generalize yet. On the third time, look to generalize the approach."

Thanks Andy - The error is now being thrown (if I run the package in the designer) but it doesn't go to the On Failure step - is that expected? Ben