I'm using OLEDB for Teradata, but it wont keep the password saved, it keeps clearing it.
Error I keep getting is:
Error 1 Validation error. Data Flow Task: OLE DB Source : SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "W" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ImportMSPLoans_W.dtsx 0 0
Anybody else got SQl 2005 DTS to import data? If so, what driver?