How can we combine more than 2 connectors in SSIS?

问题:

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)

How can I achieve this?

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.

回答1:

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. Copy data from ODBC Source to Access
2. Then copy data from Access to SQL Server

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

回答2:

After your data source, use a Multicast, which allows the data to flow to multiple destinations. It will look something like this:

(Ignore the errors on the destinations, as I'm including this as a mock-up.)