Trying to set up Ole Load, I am encountering a problem, which I could use some help with. I am able to access the source data (which is SQL Server). However, when I try to set up the Destination (which would be Teradata), I get an error stating:
"Cannot open a connection to the specified source provider, "Teradata Database", because: Class not registered."
What is this telling me? I know I am missing something probably simple in the set-up.
I thought the easy part would be connecting to Teradata, but in my case I am able to connect to the SQL Server source well and don't seem to be able to make the connection to Teradata.