File 1:

A

B

C

File 2:

E

F

G

Union All gives us:

A

B

C

E

F

G

Merge Join gives us:

A E

B F

C G

Brandie Tarvin (5/6/2013)

---

Koen Verbeeck (5/6/2013)

---

avinash.818 (5/6/2013)

---

Hi Brandie,

If I add a Merge Transform and Pull the Data into Destination,Data from each file Merges as one column in the output,what I need...

avinash.818 (5/6/2013)

---

Hi Brandie,

If I add a Merge Transform and Pull the Data into Destination,Data from each file Merges as one column in the output,what I need is a separate column...

Thanks for the question, and Hugo, thanks for the explanation 🙂

So you installed SQL Server 2008 (at least standard edition) and you upgraded the package to SSIS 2008?

Any errors/warnings during the upgrade?

Do you use a script task/component in the package?

Easy one, as I was bitten by this before. Thanks for the question.

How can you have something back...

The correct answer is wrong. Zerko is right, the explanation even says so.

Let the flaming begin 🙂

Another interesting question, thanks Hugo.

Easy one to close off the week, thanks!

Long question, but interesting.

Nice question, thanks.

haastnooit (4/24/2013)

---

I was finally able to install BIDS and open the project, but it does not upgrade automatically.

Is there a way I can force it to do that?

How can I...

Lowell (1/15/2013)

---

Thanks Koen!

I've bean my head against that 64 bit installation rock a few...

haastnooit (4/23/2013)

---

Hi Koen,

Thanks for your reply.

I have the source of the project repsonsible for this functionality and im downloading visual studio 2008 right now to be able to open it.

How...