It would be great to know more about this "tie-breaking rule", otherwise this question is just guess work.

I know you can change the source and destination tables dynamically, but I have no clue how you would handle the changing metadata.

That's a bit out of my comfort zone.

I know that some people regenerate the package dynamically every time, so that when it runs the dataflow is mapped as it should...

Does the SQL Server account uses a domain user?

You need to give this user permissions on the SSIS catalog.

Does the .dat file have clear text as data?

What is the encoding?

Can you copy paste the real error, along with everything else in the output window?

Not really a SSIS question, but here goes:

you need to put an expression on the Color property of the textfields in the rows.

Something like:

=Fields!Color.Value

Out of the box, SSIS doesn't support changing metadata.

There are some 3rd party products, such as Dataflow+ of CozyRoc that can do this.

If you need to stay with native SSIS,...

Great question to close the week, thanks.

ronmoses (11/15/2012)

---

Dag-nabbit, that'll teach me to read more carefully. I read it as "how many" and not "which"! Duh. Well at least I got it right in...

Great question, thanks Kenneth.

Steve Jones - SSC Editor (11/14/2012)

---

Koen Verbeeck (11/14/2012)

---

Steve Jones - SSC Editor (11/14/2012)

---

BTW, we are looking for some articles on deployment if any of you are interested. Not large ones,...

Steve Jones - SSC Editor (11/14/2012)

---

BTW, we are looking for some articles on deployment if any of you are interested. Not large ones, but small pieces. A few topics:

...

How can...

You need to use a proxy account in your SQL Agent jobstep.

I only see 1 row in your example.