Account Status

For the Flat File source, to set an account as enabled or disabled based on the values inside a specific column, you can add the IIQDisabled (string) attribute in the source account schema. For more information on editing the account schema, refer to Managing Source Account Schemas.

The following SQL query can be used to set up the state for the account:

select ... case when Active=1 then 'false' else 'true' end as IIQDisabled from ...