Data Services All Products
You cannot specify an error action when you use the ODBC provider type in the Microsoft SQL Server connection.
If you update the
Use DSNoptions for a Microsoft SQL Server ODBC connection by using the pmrep UpdateConnection command, the command fails.
On a Windows platform, if you execute a query that uses a Sybase IQ External Loader connection to load to a Sybase IQ target, and if the Server Datafile Directory is not accessible, the session hangs.
Workaround: When you run the mapping, ensure that the Windows machine that hosts the PowerCenter Integration Service has access to the Sybase IQ server.
Failed to check appropriate privileges for the metadata web services.