Hi, I need Help To Solve This Task... Need: Create a table that contains the product catalog configuration, both the IDs and the descriptions. This will allow us to verify that and ID is mapping to the expected Package or Component description. Approach: There are 5 xml documents, each contains product catalog configuration for the 5 catalogs (Consumer Regular, Consumer Bulk, Consumer Special, Commercial Regular, and Commercial Bulk). Create an SSIS package with a dataflow that strips the xml documents and loads them into a new table using the mapping below. Table Name: Ref.ProductCatalog (in Cable Schema) Field Name Data Mapping ProductCatalogName Name of File being processed PackageGroupID PACKAGEGROUP ID PackageGroup PackageGroup Descr PackageID Package ID Package Package Descr ComponentMin PKGComp MIN ComponentMax PKGComp MAX ComponentID Component ID Component Component Descr

You may find this post by Matt Masson (SSIS Team Blog) helpful, Using XML Source.Carla Sabotta