I am interested to hear what the business need is behind this requirement - can you provide an overview? There may be other ways of addressing it.

After reading this thread, I suspect his head will be quite big enough!

Here is an example, in pseudo-code.

1) Traditional Loop/Cursor

Foreach Executive in Person

Set Salary = Salary * 1.1

Next...

Elliott W (9/22/2009)

---

Phil Parkin (9/22/2009)

---

An example of your input data would paint the picture much more completely than just words, no matter how detailed your verbal explanation ... So far...

Elliott W (9/22/2009)

---

Phil Parkin (9/22/2009)

---

Or possibly (thinking a level up) a parent package that concurrently runs multiple occurrences of the same child package, with appropriate parameters.

I haven't tried that -...

Sounds like you got it working well - good stuff:cool:

An example of your input data would paint the picture much more completely than just words, no matter how detailed your verbal explanation ... So far I have a picture...

Use an Execute SQL task (select count(*) from ...) to assign the count to a package variable (which you will have to create) at control flow level and then use...

Or possibly (thinking a level up) a parent package that concurrently runs multiple occurrences of the same child package, with appropriate parameters.

I haven't tried that - and it doesn't sound...

Or put some other unused character there...

Assuming that the text files are the same format (same field names, types, number of fields) you can use a FOREACH loop to iterate round the files.

But I'm not going...

🙂 happens to us all

Just add the single quotes in ...

"UPDATE TB_DMNSTAGE SET DMN_STATUS = '" + @[User::DMNSTATUS] + "' WHERE DMN_ID = " + @[User::DMNID]

You could use an OLEDB Command transformation to do the update for you.

Or you could send the rows to a staging area and then run an UPDATE to do them...

This is somewhat similar to telling someone that your car is not working and asking whether anyone knows how to fix it.

Please provide more details, error messages etc, so that...

Easier and cheaper to get an IT-literate temp in for a week, I reckon.

Sometimes the development effort for a one-off task such as this just isn't worth it, IMO. But...