Issue using DRS connector stage

[xch2005]

Hi,

Facing an issue using the DRS Connector stage, the job design is straight forward.

Sybase stage -> transformer -> DRS connector stage

Basically I am using the ODBC to connecto the target database and during execution got the following error.

DRS_Connector_167: Required property /Connection/VARIANT/ODBCVariant not found (CC_PropertySet::getPropertyValueAsString, file CC_PropertySet.cpp, line 1613)

Though having set the properties, not sure on how the properties to modified or what needs to be given apart from the database type as ODBC, connection string as ODBC entry, username & password.

Appericiate your help on this.

Thanks.