Informatica - The metadata could not be determined because every code path results in an error

Severity: ERROR
Timestamp: time
Node:NodeName
Thread: WRITER_1_*_1
Process ID: 5348
Message Code: WRT_8229
Message: Database errors occurred: Microsoft SQL Server Native Client 11.0: Unspecified error

Microsoft SQL Server Native Client 11.0: The metadata could not be determined because every code path results in an error; see previous errors for some of these.
SQL State: 42000 Native Error: 11529
State: 1 Severity: 16
SQL Server Message: The metadata could not be determined because every code path results in an error; see previous errors for some of these.

Microsoft SQL Server Native Client 11.0: Invalid object name 'YourTargetTableName'.
SQL State: 42S02 Native Error: 208
State: 1 Severity: 16
SQL Server Message: Invalid object name 'YourTargetTableName.


Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO **** VALUES (****)

************************************************
Informatica is not able to find the object/Table named 'YourTargetTableName'.

Ensure that you are using the correct table name, and also check your database/Schema name as well.

In my case, it was looking for a table in a different schema.