enumerating Foreach Loop from rowset

Please let me know if I am on the right track here.

I have an Execute SQL Task that selects multiple rows from an OLE DB connection, each row containing 3 columns (data types = string, Int32, Int32). In this task ResultSet = "Full result set" and Result Set > Result Name = 0, Variable Name = [User::viewInfo] which is a user variable with Data Type = Object.

I want to use a Foreach Loop Container to enumerate over the result set rows that are contained in the [User::viewInfo] variable described above. For each resultset row I want to breakout the 3 column values and assign them to 3 corresponding variables that can be referenced in a Data Flow in the Foreach Loop.

Current settings for the Foreach Loop Container: Collection > Enumerator = "Foreach ADO Enumerator", Collection > Enumerator Configuration > ADO object source variable = [User::viewInfo], Enumeration mode = "Rows in the first table". On the Variable Mappings page I select the 3 corresponding user variables I want the rowset column values assigned to, with indexes starting at 1 (not 0).

Thanks - Dana Reed

It sounds spot on to me Dana!

-Jamie

Enterprise class not registered 6.5

Today morning i tried connecting to sql 6.5 through enterprise edition got the following error
SQL ole object could not be registered class not registered (80040154)
I did shut down and restart, stopped and restarted the servicesAs obvious this is a problem with the class or the associated OLE dll not being registered in the registry properly . You can use the regsvr32 utility to re-register it :-

regsvr32 (path)\binn\sqlole65.dll

And replace (path) with the full drive/directory that SQL Server is installed into.|||Thanks works very good

One more question

How best to display data on web without knowing any language|||I think its not possible to work if you don't know any language ( in terms of IT). Can you rephrase your question agian.|||I just know sql and html the basic

any one language i can use to represent data on web and easy too learn

like combination or reporting tools ( crystal report) and something else too|||Then no issues in representing the data on a web page.
ASP with SQL is best combination I've seen so far (as I'm concerned).

Refer to MSDN & Technet for SQL for further information.|||Representing data using sql and asp is enough

I mean will it allow the user to choose say dates if i represent it on a drop down menu ( can asp do it i mean)

In short will i be able to represents most of the data using ASP (JUST)

OFCOURSE BESIDE SQL IN PROCEDURE OR FUNCTION