ssis2008 almost drive me crazy.
i opened a dataflow task by double click, then i dragged and dropped an OLE DB source component, a data conversion component and a "union all" component. i configured the source so it had an output column named "BRANCH_CODE".
after connecting the source and the conversion component, i set up the conversion as following:
type:DT_STR (the original type is DT_WSTR)
after i connected the union component to the conversion, there was a small red cross on the union component,
indicating that The package contains two objects with the duplicate name of "BRANCH_CODE(153)" and "BRANCH_CODE(99)".
and i could not open the advanced editor of the union component.
any suggestions will be greatly appreciated.
Interested in BI related technologies
View Complete Post