DSXchange

Hi, I am having around 20 millions of records in a dataset to insert into SQL Server using ODBC Stage, but i am getting very poor performance of 300 rows /sec in inserting those records. There are no Indexes / keys on the table. Can we do any kind of optimization setting in ODBC stage. Please help m...

Please check out the privileges of odbctrace.out file in /dspx00/Ascential/DataStage/branded_odbc, It might be possible that you don't have write access to this file