I have been searching for a method when using a data driven query that would
enable me to insert multiple row from a single input record. Has anyone
managed that process?

TIA -- Ron

Not quite sure what you mean.

1. Multiple rows for a source row into 1 destination object?
2. Multiple destination rows, multiple destination objects and a single
source row.

In any event I would not be using the DDQ.

I would be doing something very much like this

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Ron Schmidt" <Schmidt.ronald (AT) mayo (DOT) edu> wrote

Thanks for the response.



I was looking to take a single input and create multiple output records and
multiple updates. I was considering the DDQ since it would enable me to
perform multiple operations (inserts and updates) in a single pass. Thanks
for the link. I will use that approach and perform multiple passes.


Ron

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote