SQL2005 SSIS Table Mapping

I have a simple SSIS that reads a table and exports to a .csv file.

The problem is that I have added a field to my table but the outpit to .csv does not see the additional field.

How do I update the mapping to add the new field to the output .csv file?

Who is Participating?
Nathan RileyConnect With a Mentor FounderCommented:
You need to update the step that creates the .csv file and reset the columns so that it will see the new one.
Nathan RileyFounderCommented:
is it only 1 step or 2?
Sreedhar VengalaSr. Consultant - Business IntelligenceCommented:
Ok if you are using : Flat File Connection Manager to dump data into CSV -> in ConnectionManager ->Columns -> Reset Columns
and in your Flat File Destination Editor -> mapping -> Map Items by Matching Name (will get contextmenu by right clicking on existing mappings)
jdr0606Author Commented:
I have attached a screenshot of where I'm having the issue.

As you will see the available input columns has a field at the end labeled "DueDate".

That field does not exist in the Available Destination file or does it appear below to be mapped in either the input or destination column list.

Where do I need to refresh the mapping or do I just need to redo the project.

Sreedhar VengalaConnect With a Mentor Sr. Consultant - Business IntelligenceCommented:
Ok..one more step in between in your File Connection Manager Editor -> Advanced -> Create a new column matching the one added in Table

and then when back to : FlatFile Destination Editor: anywhere on the mapping : right click and set the mappings accordingly
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.