In couple of packages in our project got error “Item has
already been added. Key in dictionary: '<number>' Key being added: '<number>'”.
After observing properly issue was resolved. Here is detailed explanation of
the issue.
In Data Flow Task (DFT) there source lookup and destination adaptor.
From source one date was selected; let’s call it ‘FromDate’. In Lookup one date of fetched and output name
of date was also ‘FromDate’. So now the downstream pipeline was having two date
columns with same name.
All other defaults transformation of SSIS will resolve this conflict
by appending the Lookup to the column. But the PDW destination adaptor was
unable to do this. Hence it was giving error as “Item has already been
added. Key in dictionary: '<number>' Key being added: '<number>'”
Example of columns with same name in pipeline
Example of components solving the same column name by
appending component name
Solution: Name the columns uniquely in the pipeline. Since
the PDW destination adaptor is not capable of handling same name column as
other components do.
Keyword: APS, PDW, Destinaton, Microsoft Parallel Data Warehouse, Microsoft Analytics Platform