karan@SqlLearner (9/19/2016)
Thank You so much for your reply.We tried Attunity provider but we were getting some error "TPT Export error encountered during Initiate phase", because we could not fix that error we changed back to ODBC.
With just change in driver everything started working but very slow.
is Attunity driver faster than ODBC?
Attunity is optimized for performance, so I believe it should be faster.
Regarding the TPT error, make sure the query syntax is valid.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP