Delay Validation with SSIS Tasks

A little bit too easy. But then again, it's Monday...

Thanks for the question.

Hmmm, I thought Pre/PostExecute would give more info about the various iterations of the loop. Apparently not.

Looking at the package design, everything seems OK, so I don't really have a...

kd11 (7/6/2012)

---

You need to have the package locally. You can import it to your project in BIDS by right-clicking packages and choose Import Package. Navigate to the server and select...

Steve Jones - SSC Editor (7/6/2012)

---

I do like the T-SQL enhancements. IIF and Window functions, but my favorite would be readable secondaries, and the ability to pick them with read-intent...

Celko did a helpful post AND he gave someone a compliment.

I'm not kidding.

You need to have the package locally. You can import it to your project in BIDS by right-clicking packages and choose Import Package. Navigate to the server and select the...

My guess is that the other of the question wanted to make 2 "correct answers".

Meaning that if you selected 10 it is correct, or if you select 12 it is...

Aaah, nostalgia 🙂

Good to know. Thanks for posting back.

If your source system is a database, you could add WHERE NOT EXISTS to your SQL SELECT statement, so that you only read rows that don't exist in the destination.

Why? A table has per definition no order defined. It doesn't make sense to go through all sorts of troube just to insert two rows after another two rows.

You are selecting an entire resultset into a single string variable.

This means every row is overwriting the previous one. The result you see is the one from the last row.

You...

In that case you'd need a table variable or a temporary table.