Hello, I hope some one can help explain and that it is an easy fix. Earlier today I was in an SSIS package, it has two different data connections to connect to Teradata, one uses ODBC and the Teradata connection info, and the other uses Affinity. I had an issue earlier, but a reboot solved, and there were no issues with packages or cubes.
Now when I open a SSIS package, I get errors and a message says its the package is corrupt. I try to make a new one with the wizard to build off the production one, and I get the same issue, and I get this same error message if I open any of my packages.
The error is:
Error 1 Error loading Load SQL SDyF.dtsx: The connection type "MSTERA" specified for connection manager "Teradata Connector 1" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. C:\~\Load SQL SDyF.dtsx 1 1
I recall seeing this MSTERA name, I must have inadvertently left it on that when existing the package so I presume. This connector is used all throughout all my SSIS packages.
How can I get the connector changed correctly so when I open the package it wont read this wrong info and give the corrupt message again?
Many thanks,
JPQ