Appending to a recordset destination

Hi,
We have a data-flow that extracts from a raw file and inserts into a datareader destination.

The data-flow requires DelayValidation=TRUE because of the raw file source (http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx)

Unfortunately it also requires DelayValidation=FALSE because of the Datareader destination (http://blogs.conchango.com/jamiethomson/archive/2005/10/20/2284.aspx)

So basically we can't do it this way.

We'd like to replace the raw file destination with a recordset destination but we have to be able to append to it.

Is there a way of appending when using a recordset destination?

Thanks in advance!
-JamieJamie,

I believe that your first statement is not correct for the raw file source (just for the raw file destination) as long as you have already created the raw file before the dataflow with the raw file source validates. So you could create a empty raw file with just the correct metadata and then set delay validation to false and what you want to do should work.

In answer to your question, I do not believe we have a way to append using a datareader dest.

Thanks,
Matt|||Matt,
That's true - but I don't really want to be moving raw files into a production envioronment. We want to deploy the packages and nothing else!

We are thinking of writing a custom destination adapter that appends to a recordset. Do you think that is possible?

I guess its a question of which is the least nasty workaround so your suggestion IS something to consider.

-Jamie

P.S. Is it worth raising a DCR asking for the ability to append to a recordset destination? This would mean it could be used in place of a raw file which could be rather useful.|||Hi Jamie,

I am certain it is possible to create a custom destination adapter to do what you want. I don't know that it wouldn't be really nasty to do so. I think the empty raw file is a little more hacky but much easier to do.

I can't see why you couldn't raise this as a DCR. I don't know whether it would make it into the next version or not but that isn't reason not to ask.

Thanks,
Matt|||OK. Well I have done. :)

http://lab.msdn.microsoft.com/ProductFeedback/thankyou.aspx?FeedbackID=FDBK42005&submit=true

-Jamie