The SQL editor for SQL query overrides in a Source Qualifier or Lookup transformation can hold a maximum of 32,767 characters.After 32767 characters the query will be truncated and no more characters can be entered.
If a SQL override of more than 32K characters is needed do one of the following:
Create a database view using the SQL query override.
Create a source definition based on this database view.
Use this new source definition as the source in the mapping.
Create the query override in a text editor.
Edit the Source Qualifier transformation.
Click on properties.
Delete the SQL Query (or Lookup SQL override in a Lookup transformation).
Click in this field and hit the space bar so the focus is on the field and a blinking cursor appears.
Copy the SQL from the text editor.
Paste the SQL at the blinking cursor.
ANother option would be to use a stored procedure transformation in your mapping.
Then set the Stored Procedure Type to Target Post Load.
CR 89498CR 107167
What can we do to improve this information (2000 or fewer characters)