Could anyone please also advice what is there is SQL 2014 for below Component Class IDs. Below ones are from 2008: -
DTSAdapter.ExcelSource.2
DTSTransform.RowCount
One of the post stated below Componentes mapping. However, looking for what is there for above two also in SQL 2014.
SSIS 2008 --> SSIS 2014
"SSIS.Pipeline.2" --> "Microsoft.Pipeline"
"DTSAdapter.FlatFileSource.2" --> "Microsoft.FlatFileSource"
"DTSTransform.DerivedColumn.2" --> "Microsoft.DerivedColumn"
"DTSTransform.ConditionalSplit.2" --> "Microsoft.ConditionalSplit"
"DTSTransform.UnionAll.2" --> "Microsoft.UnionAll"
"DTSAdapter.OLEDbDestination.2" --> "Microsoft.OLEDBDestination"