• It should never be neccessary to manually change the output columns in a data destination component; SSIS is intelligent enough to automatically get the latest table meta data when the component is edited.

    If it is not getting the latest metadata, check the "Delay validation" property for the destination component.

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”