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 :-(
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.