How can I make identical output from a transformation go to two separate places e.g., an OLE DB destination and a DataReader destination?
如何从转换中将相同的输出转到两个单独的位置，例如OLE DB目标和DataReader目标？
Background:
背景：
I have an existing package that reads data from a text file, does some transformations, and loads the data into a SQL Server table.
我有一个现有的包，从文本文件中读取数据，进行一些转换，并将数据加载到SQL Server表中。
Now I'm trying to make the package be callable from a reporting services report (SSRS). I'm following the instructions here: http://msdn.microsoft.com/en-us/library/ms159215.aspx
现在我试图通过报告服务报告（SSRS）使包可以调用。我按照这里的说明操作：http：//msdn.microsoft.com/en-us/library/ms159215.aspx
It says to make my data go into a DataReader destination and then the report will have access to that. So I want the output of the final transformation to go to both the SQL table, and the DataReader destination.
它说要使我的数据进入DataReader目的地，然后报告就可以访问它。所以我希望最终转换的输出同时转到SQL表和DataReader目的地。
2 个解决方案
#1
4
Use the MULTICAST and send to a "DataReader destination" and "OLEDB destination" in your SSIS package.
使用MULTICAST并发送到SSIS包中的“DataReader目的地”和“OLEDB目的地”。
When you create your datasets in SSRS, you should use the name of the Output object from your SSIS package. Your dataset in the report should then populate with fields, data, etc that from the SSIS package.
在SSRS中创建数据集时，应使用SSIS包中的Output对象的名称。然后，报表中的数据集应填充SSIS包中的字段，数据等。
#2
1
Perhaps the Multicast step?
也许组播步骤？
#1
4
Use the MULTICAST and send to a "DataReader destination" and "OLEDB destination" in your SSIS package.
使用MULTICAST并发送到SSIS包中的“DataReader目的地”和“OLEDB目的地”。
When you create your datasets in SSRS, you should use the name of the Output object from your SSIS package. Your dataset in the report should then populate with fields, data, etc that from the SSIS package.
在SSRS中创建数据集时，应使用SSIS包中的Output对象的名称。然后，报表中的数据集应填充SSIS包中的字段，数据等。
#2
1
Perhaps the Multicast step?
也许组播步骤？