This is an unusual requirement - let's make sure I understand.

Say your input file has 10 columns and, out of those, 8 columns contain only nulls.

You want to load...

ar-727381 (9/23/2009)

---

i cannot untick them because there are around 40 columns with 100's of rows in the csv file. so checking if a column is null or not is not...

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...