我们如何在SSIS中组合两个以上的连接器? [英] How can we combine more than 2 connectors in SSIS?

问题描述

我对SSIS非常陌生.我的任务是从ODBC源A中获取数据，然后传输该数据以进行访问，然后传输到SQL.我相信SSIS可以完成此任务.但是，根据我看到的各种示例，它们使用单​​个源和目标.我找不到一次使用3个或更多连接器的任何方法.再次总结一下，我必须按照以下方式迁移数据: ODBC源A->访问-> SQL Server(当访问结束时导入)

I am very new to SSIS. I have a task of taking data from ODBC source A, then transport that data to access, thereafter to SQL. I believe SSIS can do this task. However, according to various examples I have seen, they use a single source and destination. I couldn't find any method for using 3 or more connectors at a time. TO summarize again, I have to migrate data in following manner: ODBC source A -> Access -> SQL Server (when import is over at access)

我该如何实现?

请不要要求我删除访问权限或任何其他数据源，因为如果ODBC数据首先进入访问权限，则会移动SQL Server中的正确映射和数据.

Please don't ask me to remove access or any other data source as proper mappings and data in SQL server is moved if the ODBC data goes into Access first.

推荐答案

据我所知，您只希望在将数据复制到Access之后将数据复制到其最终SQL Server目标.

From what I can gather you only want the data copied to its final SQL Server destination after it has been copied to Access.

1. 将数据从ODBC源复制到Access
2. 然后将数据从Access复制到SQL Server

您可以使用2个数据流来完成SSIS:

You can use 2 data flows to accomplish that is SSIS:

这篇关于我们如何在SSIS中组合两个以上的连接器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！