No, I've had multiple data flows in one data flow task.

What error are you getting?

Generally, the higher column IDs are the ones added last, but that can be wrong if you're using the table designer GUI and tables are being rebuilt instead of altered.

I'm...

In the workflow, after you import the first file, add an Execute SQL Task, with a full recordset. Store that in a local object variable, and create a For...

Are you creating the package in BIDS or some other interface? Multiple data flow tasks in BIDS is dead easy, just drag and drop them onto the workflow.

rmechaber (9/8/2011)

---

Now that's just downright creepy: what are you doing...

ChrisM@Work (9/8/2011)

---

GSquared (9/8/2011)

---

rmechaber (9/8/2011)

---

Chris, thanks for posting that: this is a fascinating article and real food for thought. ...

I don't understand what you're trying to update. I can't see how your starting data relates to your ending data.

Updating XML in T-SQL is through the "modify" method. ...

On the original topic (instead of the much-deserved Celko-bashing), you can force separate ordering within Union (All) queries by adding a "Sequencer" column.

For example:

select 1 as Seq, MyColumnA, MyColumnB

from MyFirstTable

union...

rmechaber (9/8/2011)

---

Chris, thanks for posting that: this is a fascinating article and real food for thought. I'm not...

rmechaber (9/8/2011)

---

GSquared (6/2/2011)

---

Per http://www.thefreedictionary.com/null, yes, since null is a synonym for zero.

However, most DBAs would assume that null = no assigned value, not null = 0 (linguistic equality as well...

ChrisM@Work (9/8/2011)

---

GSquared (9/8/2011)

---

ChrisM@Work (9/7/2011)

---

GSquared (6/3/2011)

---

...As an illustration of this, I once had someone assert to me that "evolution is impossible, nobody has ever seen one species change into another". ...

IceDread (9/6/2011)

---

GSquared (9/6/2011)

---

Per a profile I recently read, one of the "leading lights" of Anonymous is a young woman whose father is very, very proud of the things his daughter...

ChrisM@Work (9/7/2011)

---

GSquared (6/3/2011)

---

...As an illustration of this, I once had someone assert to me that "evolution is impossible, nobody has ever seen one species change into another". This is...

Tom.Thomson (9/6/2011)

---

GSquared (9/6/2011)

---

It's always seemed to me that, if a billion is a million million, shouldn't a trillion be a billion billion? And, honestly, a thousand should be a...

SwayneBell (9/7/2011)

---

I was disappointed too Grant, what with my movie...