ODBC Connector _Before SQL section:Insert issue

[smile.achieve]

I am using a ODBC connector stage and trying to insert and select on it.

I am tryin this way. In Before SQL section I am trying to insert data into table XYZ and in the select section i am writing a select col1,col2 from XYZ. While the connector and results are working fine. I am not seeing any inserted records in table XYZ. I suspect that once the ODBC connector stage is executed it is deleting all the records.

Also I have not used any option or sql statement to delete records of XYZ. Still this problem. Can some one let me know why inserted records are not available.

[ray.wurlod]

Look in the job log to determine the result of the Before-SQL statement.

[chulett]

If by "results are working fine" you mean you know the inserted records are being used by the select, then I suspect the records are rolling back. Perhaps a commit is in order?