Processing multiple rows and multiple columns in SSIS

I previously posted a problem with result set bindings but I have not been able to resolve my problem. I guess all this comes with being new to programming in this environment! Anyway, I am trying to figure out how to process from an ADO.NET connection multiple rows with multiple columns. I have to read and manipulate each row. I was originally looking at using a foreach loop but have not been able to get it to work. One reply to my previous thought I should be using a data task to accomplish this. Could someone tell me the best way to handle this situation? As a note, I am new to programming in SSIS and basically trying to learn it as I go so please bear with me! Thanks in advance!

My first suggestion would be to run through the BOL tutorial for SSIS. This will show you some information on the data flow task and some of the things it can help you do. I would agree with the previous post that you should be using a data flow task, with an ado.net connection source, the misc. transformations that will manipulate your data and then your destination.

You might consider picking up one of the various SSIS books if you are going to be doing any amount of work in this environment (either the wrox professional or Kirk Haselden's books are both good starts).

process could not execute 'sp_repldone/sp_replcounters.. Another log reader is replicatin

Hilary, Paul.
I have read some of your threads on some sites
regarding this. You had suggested that maybe
restarting sql agent/server would resolve this.
I tried that with no luck. I have yet to reboot
the server, because it's in a production
enviroment. I will try that this weekend at
night. However, i was wondering. I get this
error quit a bit on all publications going
through this particular distributor. resources
are fine on both the publisher and distributor.
Is there anything else I can check to resolve
this. reinitializing isn't an option.
Thanks guys..
comb
stop the sql server agent. If this does not solve the problem, stop it,
issue a sp_replflush and then restart it.
If this does not clear the problem, enable logging and post the error
message you get back here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1bc491484347f0de9896b5@.news.newsreader.co m...
> Hilary, Paul.
> I have read some of your threads on some sites
> regarding this. You had suggested that maybe
> restarting sql agent/server would resolve this.
> I tried that with no luck. I have yet to reboot
> the server, because it's in a production
> enviroment. I will try that this weekend at
> night. However, i was wondering. I get this
> error quit a bit on all publications going
> through this particular distributor. resources
> are fine on both the publisher and distributor.
> Is there anything else I can check to resolve
> this. reinitializing isn't an option.
> Thanks guys..
> comb