Effective in Informatica 10.0, Microsoft SQL Server contains the following changes:
You can use the ODBC connection type to connect to Microsoft SQL Server.
You can upgrade your existing connections by using the pmrep and infacmd commands. When you run the upgrade command, all the existing connections are upgraded.
The existing Microsoft SQL Server connection is deprecated and support will be dropped in the next major release. You can run the existing mappings without manual updates. If you are using SSL connections, you must select the provider type as ODBC in the connection, and configure SSL in the DSN.