Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Does DTS support ADO Recordsets?
0 views
Skip to first unread message
Don Flynn
Jun 28, 2000, 3:00:00 AM6/28/00
to
I'm writing a VB program to transform data, and would like to leverage the
power of the DTS engine. However, I have the need to massage data using ADO
and am left with an ADO recordset I would like to turn around and use as the
source to a DTS data transformation. However, I don't think DTS (SQL Server
7.0) supports this.
power of the DTS engine. However, I have the need to massage data using ADO
and am left with an ADO recordset I would like to turn around and use as the
source to a DTS data transformation. However, I don't think DTS (SQL Server
7.0) supports this.
Can someone validate this? Also, what is the best work-around? Should I
save the recordset out to a temporary table and then use DTS to transfer?
Sounds hokey.
Thanks.
Don Flynn
Euan Garden
Jun 28, 2000, 3:00:00 AM6/28/00
to
You are correct DTS does not support this, however if you persist the ADO
recordset to XML you can read it again with the Merant OLE DB provider for
XML, this works with DTS in 7.0
recordset to XML you can read it again with the Merant OLE DB provider for
XML, this works with DTS in 7.0
-Euan
"Don Flynn" <don....@pnl.gov> wrote in message
news:OMNiirV4$GA.134@cppssbbsa04...
0 new messages