Phil Parkin (3/10/2011)

---

I don't think it should be that messy - depending on your coding skills, of course 🙂

For each table in [array]

create destination table

copy data...

ben-732740 (2/22/2011)

---

I would like to have an SSIS package which "watches" a table for a certain condition, and when the condition is met, produce a file.

I've thought of a couple...

Koen Verbeeck (2/22/2011)

---

Phil Parkin (2/21/2011)

---

You are correct. But bear in mind that the person posting the question was an ultra-newbie and your advice was directed at them, not at an...

Hi Rockey,

Your expression looks good. No problem in that.

I had encountered same kind of error before and it might be coming because of data type mismatch b/w source &...

Phil its totaly depends on the business needs (if I am correct :cool:). Sometimes we can afford to force our package to execute successfully, although some tasks got failed in...

Hi,

This error description indicates that three tasks in you SSIS package got failed that leads to failing the entire package.

Setting property MaximumErrorCount = 1 indicates, inside this package scope...

Hi,

When you say you are creating event handler at Package level that means it will be propagate down to child events when the events fires. It doesn't depends on the...

One reason that comes into my mind is might be because your data (which need to be sent to XML destination) is ill formatted. Just for example if your query...