Hi All,

In SQL Server 2000 DTS, I had an Active X script that, using ADO,
performed the following basic operation:

Retrieve a list of account numbers through Recordset1
While Not Recordset1.eof
Build a sql statement based on fields from current row of
Recordset1
Open Recordset2 based on the sql statement built
Run an update query based on results from recordset 2
Loop

I want to bring this over to SSIS, but i'd like to take advantage of
the most current "ways of doing things" instead of just using SSIS's
activex script.

Does anyone have any recommendations on the best way to handle this
type of thing in SSIS? A script task? A script component? I've never
really worked w/ ADO.net so if it involves that I'd have to pick up
some pointers... any suggestions?

Thanks in advance
Jeff

Read the resultset into a Recordset Destination

You can then loop over that.

(You could also do this using an ExecuteSQL task)

We do something similar here

Shredding a Recordset
(http://www.sqlis.com/default.aspx?59)

You would build the SQLStatementSource in a Property Expression.

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"Jeff" <jpasqua (AT) gmail (DOT) com> wrote