[CR #536684] Projects that use Adaptive Server as the source and that contain the IQ Loader DB via Insert Location component fail if the network packet size for the component is larger than or equal to the maximum network packet size of the Adaptive Server.
Workaround: Before you execute the project:
Connect to the Adaptive Server and execute sp_configure ‘max network packet size’ to display the maximum network packet size Run Value for your Adaptive Server.
In ETL, enter a packet size for IQ Loader DB via Insert Location that is less than or equal to the Adaptive Server maximum network packet size Run Value obtained in step 1.
For example, if your Adaptive Server maximum network packet size Run Value is 2048 bytes, your ETL packet size for the IQ Loader DB via Insert Location component must be less than to equal to 4 as 4 translates to a Adaptive Server Run Value of 4*512=2048 bytes.
