Of DTS And Recordsets

[EdwinGene]

I need to return a recordset from a table in my SQL Server connection, and then process each individual item in the returned recordset. The returned recordset is going to have only one column. I'm thinking this has to be done using an ActiveX Script Task, but I haven't yet been able to figure out how to do it.

Has anyone done this before, or know how to do it?

 

[dbomrrsm]

can you give more detail - ie what forms the recordset you want returned (eg a customer name, customer id) and what you want to do with it i.e. update it and write it back to the table. examples of what data looks like before and after is always useful - along with details of which table/s the data is coming from and where the processed data is to be stored.

[blue]DBomrrsm[/blue]

 

[EdwinGene]

I found it. I just had to look for the right thing. My brain finally realized that Rowset would lead me where I wanted to go.

Thanks, anyway.