如何在转换期间使用 SSIS 2008 脚本组件添加行？
我有一个 SSIS 2008 脚本组件，它设置为转换（因此它有输入和输出），我想要做的是在输入中获取 1 行，并可选择输出多行。
2005 年出现了 AddRow 和 CreateNewOutputRows方法，但这些似乎在2008年不可用。
那么如何在转换过程中添加行呢？
I have a SSIS 2008 script component which is setup as a transform (so it has an input and output), and what I want to do is take 1 row in an input and optionally output multiple rows.
In 2005 there was the AddRow and CreateNewOutputRows methods but those seem not to be available in 2008.
So how do I add rows during the transformation?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您的问题可能是您将组件配置为同步转换。如果这样做，您将无法在输出中添加“额外”行。
但是，如果情况并非如此，那么 2005 年的所有功能都会在 2008 年中出现。这包括 CreateNewOutputRows 方法，我认为在本例中您不需要该方法。它还包括 AddRow 方法 - 该方法仅在输出缓冲区（可能名为 Output0Buffer）上可用，如果输出是同步的，您将看不到该缓冲区。
查看此以设置异步脚本。
Your issue is likely that you have the component configured as a synchronous transform. If you do, you won't be able to add "extra" rows on the output.
If that's not the case, however, then all the facilities of 2005 are present in 2008. This includes the CreateNewOutputRows method, which I don't think you want in this case. It also includes the AddRow method - which will only be available on an output buffer, probably named Output0Buffer, which you won't see if your output is synchronous.
Review this to set up an asynchronous script.