Solve the problem of "unable to get managed connections from the runtime Connection Manager" When SSIS connects to the ODBC Data Source

Recently, I tried to use sqlserver2005 integrate services to extract data from heterogeneous databases and use the ODBC-connected teradata as the data source. Refer to the "SQL Server 2005 database development details" (Electronic Industry Press Hu baijing Yao Qiao Mei) P361-363, the operation steps in SSIs are as follows:
(1) Right-click the Connection Manager and choose create connection> ODBC to create an ODBC connection.
(2) create a datareader source. Right-click the source and choose advanced editor> Connection Manager tab. In Connection Manager, select the ODBC connection created in the previous step.
After this step, an error will be reported: "the data flow task [datareader source [1] error: unable to get the managed connection from the runtime Connection Manager"
Depressed. Read this text repeatedly and check the online Article (Http://www.yeyan.info/SSIS-sybase-t449843.htm, http://www.yeyan.info/Topic.aspx and so on) seems to have no solution. In desperation, you can only try to download sqlserver SP1 and oledb provider for teradata (the earthquake broke the submarine cable, so it took three hours to download it: <, SP1, the latter has not been downloaded yet ). However, the situation still persists after SP1 is installed.
I can only touch it: (, fortunately, I finally succeeded:
(1) Right-click the Connection Manager and choose create ADO. net connection from the shortcut menu.Program-ODBC Data Provider
(2) create a datareader source. Right-click the source and choose advanced editor> Connection Manager tab. In Connection Manager, select the ODBC connection created in the previous step.

I spent 3 days, and it was depressing. Fortunately, I solved the problem :-). "SQL Server 2005 database development details" is a good book that covers all fundamentals, but the meticulous letter needs to be strengthened. This bug will lead to false positives :-(