September 19, 2016 at 1:06 am
Hello Guys,
I really need your help in figuring out answer to below question,
We have one SSIS package which brings data from Teradata Source to SQL Server Destination. We are in process of upgrading our SSIS from 2008 to 2014 version. Earlier we were running SSIS in 32 bit environmnet using OLEDB drivers for both Teradata and SQL Server.
During upgrade we found OLEDB does not provide 64 bit provider for Teradata, so we planned to change it to ODBC.
Now with ODBC Teradata driver (in 64 bit environment) SSIS is taking more time then OLEDB environment (in 32 bit environment).
Can someone help me understand why? Should i move back to OLEDB 32 bit provider.
Any help is highly appreciated.
Thank You
September 19, 2016 at 2:08 am
What about the Attunity Teradata connector?
https://www.microsoft.com/en-us/download/details.aspx?id=44582
(you need Enterprise Edition though)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2016 at 1:10 pm
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?
September 19, 2016 at 1:49 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply