How do I import Informatica mappings into SSIS

Question

I have a client that is upgrading from SS 2012 to 2014 and wants to drop Informatica ver 9.6 in favor of SSIS. Toprevent the cost and labor of creating the SSIS packages rom scratch, they want me to try to import thrm into SSIS. Is there a way to do so?

Answer 1

• The key Difference between the two is the type of expression language used to derive the data

SSIS	Informatica
Mathematical	Character
String	Conversion
Date/Time	Date
NULL	Numerical
Type Casts	Scientific
Operators	Special
Test

• Sorter Transformation in Informatica and Sort Transformation in SSIS are similar but in SSIS duplicates are removed by setting the Eliminates Duplicatesproperty toTRUE whereas in Informatica, the same thing is accomplished by checking the Distinct property.

• In Informatica and SSIS they follow modular approach but the only difference is that SSIS builds modularity into its packages through use of the container hierarchy & Informatica promotes building libraries

• Informatica uses Sequence transformation to generate the Surrogate key. In SSIS we don’t have Sequence transformation. Instead we use Script transform component for the same purpose

• Both of them uses Aggregate function but SSIS contains few aggregate functions only

• Informatica uses Debugger in Informatica Designer to debug the mapping and SSIS’s debugging capabilities are provided through the use of Visual Studio 

  this are some points which help you lot.

http://dwhlaureate.blogspot.in/2012/09/differences-between-informatica-and.html