Workflow Soluiton

I recently added a new column to a database table that is used in a Workflow project.  I recompiled the Integration project to pick up the new column, which is now displayed in the Query preview pane as well as in the Selected columns list.  I then reloaded the Workflow project which includes the updated Integration project.  When I am in the Workflow project and review the properties of the database table object from the Integration project, the new column is not displayed.  I also tried adding the Integration to a different Workflow project (which did not previously use it) to see if the newly added column would be displayed.  It was not.   See the attached document for screen prints from the Integration project and the Workflow project.  Is there something special that needs to be done when adding a column to an existing table generator? 

Attachment(s)

Issue Updating An Existing Table Generator.docx   46 KB 1 version

This was a known issue that we fixed:

Date: Monday, April 02, 2012 9:19:21 AM
Message:
2736753 SQL Table generator component datatype doesn't update to include new columns even after multiple adjust definitions and recompiles.

This may/may not be in one of our rollups. Which version of WF are you using? If there's a need, you can contact Support and get it pushed down to the appropriate rollup version.
 

I am using Workflow Version 7.1.1460.1974  Do you know which version includes the fix?

From what I can tell, the SP2 rollup is the earliest version that has this fix (which will be 7.1.1600.*)