I am trying to link a Teradata server to a SQL Server. I am getting various errors surrounding making the connection. I have created a SystemDSN and included the authentication credentials in it, but I get Authentication Failed message.
Any tips? I have installed the Teradata OLE DB Provider...
I have done something like this before. I don't have the code. Essentially, you write a query that creates the drop statements for all the FKs (A), create query that creates the add statements(B).
Run A
Truncate target tables
Run B
I am trying to link a Teradata server to a SQL Server. I am getting various errors surrounding making the connection. I have created a SystemDSN and included the authentication credentials in it, but I get Authentication Failed message.
Any tips? I have installed the Teradata OLE DB Provider...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.