I cannot perform a drag and drop operation, such as connecting ports.
Review the error message on the status bar for details.
I cannot connect a source definition to a target definition.
You cannot directly connect sources to targets. Instead, you need to connect them through a Source Qualifier transformation for relational and flat file sources, or through a Normalizer transformation for COBOL sources.
I cannot connect multiple sources to one target.
The Designer does not allow you to connect multiple Source Qualifier transformations to a single target. There are two workarounds:
Since target definitions are reusable, you can add the same target to the mapping multiple times. Then connect each Source Qualifier transformation to each target.
Join the sources in a Source Qualifier transformation.
Then remove the WHERE clause from the SQL query.
The source has QNAN (not a number) values in some columns, but the target shows 1.#QNAN.
Operating systems have different string representations of NaN. The Integration Service converts QNAN values to 1.#QNAN on Win64EMT platforms. 1.#QNAN is a valid representation of QNAN.
I entered a custom query, but it is not working when I run the workflow containing the session.
Be sure to test this setting for the Source Qualifier transformation before you run the workflow. Return to the Source Qualifier transformation and reopen the dialog box in which you entered the custom query. You can connect to a database and click the Validate button to test the SQL. The Designer displays any errors. Review the session log file if you need further information.
The most common reason a session fails is because the database login in both the session and Source Qualifier transformation is not the table owner. You need to specify the table owner in the session and when you generate the SQL Query in the Source Qualifier transformation.
You can test the SQL Query by cutting and pasting it into the database client tool (such as Oracle Net) to see if it returns an error.
I used a mapping variable in a source filter and now the session fails.
Try testing the query by generating and validating the SQL in the Source Qualifier transformation. If the variable or parameter is a string, you probably need to enclose it in single quotes. If it is a datetime variable or parameter, you might need to change its format for the source system.