CODEWITHSUNDEEP
ssis
rigamonk
rigamonk

Reputation: 1181

How to add a new column to SSIS destination

I just added a new field to my OLE DB Source in an SSIS package. It then goes to a Flat file Destination. In the Flat file destination object, the field shows up under available inpt columns but doesnt show up anywhere else (Available destination Columns, or the bottom box that lists fields)

How do i get this as an available destination field?

Upvotes: 1

Views: 3561

Answers (2)

Tab Alleman
Tab Alleman

Reputation: 31795

Go into the Flat File Connection manager used by your destination object, go to Advanced, and click "New", then add the column properties.

Upvotes: 1

Oscar
Oscar

Reputation: 13990

Delete the destination and recreate it, it usually works.

Upvotes: 0

Related Questions