-1

I've got a data flow task which has a conditional split which then leads to two different flat file destination. The thing that is puzzling me, is why do I have different 'available destination columns' in the flat file editor's mappings tab than I do in the alternative flat file editor's mapping tab.

I'm hoping this is a Newbie error, but it's had me stumped all morning.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Graham Reavey
  • 25
  • 1
  • 6
  • Can you expand on `why do I have different 'available destination columns' in the flat file editor's mappings tab than I do in the alternative flat file editor's mapping tab`. Is it possible that by "Alternative editor" you mean "Advanced editor?" Can you provide a screenshot or two of the differences? – Troy Witthoeft Oct 04 '17 at 14:11

1 Answers1

0

At the bottom of the screen, is a box with the connection manager.

enter image description here

If you have two different flatfile destination then you should have a connection manager for each. Inside those objects is where the columns for each destination is defined. Double click them and examine the column definitions for each. They are probably different, which is why you have a different set of columns available on the mapping page for each of your destinations.

Troy Witthoeft
  • 2,498
  • 2
  • 28
  • 37