conversion from Informatica to SSIS

While most Informatica components will directly port into SSIS, some will require 3rd party components. The Pragmatic Works Task Factory product for example gives SSIS more powerful tasks and data processing components. The below list shows a few of the common Informatica components and how they will port to SSIS. For a more complete list, please click here. Informatica SSIS Session Native Data Flow Command Task Factory Advanced Process Task Worklet Task Factory Advanced Execute Package Decision SSIS expressions Assignment SSIS expressions Database connectors Standard SSIS OLE DB \ ODBC \ ADO.net source and destinations Cloud connectors Many handled by Task Factory Aggregator Aggregate Transform Expression Task Factory Advanced Derived Column Transform Filter Task Factory Filter Transform Joiner Merge Join Lookup Lookup Transform (connected) or Task Factory Advanced Derived Column Transform (disconnected) Router Task Factory Advanced Conditional Split Sequence Generator Task Factory Surrogate Key Transform Sorter Sort Transform Update Strategy Task Factory Upsert Destination XML Creation Task Factory XML components Maplet Task Factory Data Flow Nugget

Source:http://www.pragmaticworks.com/services/informaticamigration