Post reply

SSIS DataReader Destination used by a parent package with DataReader Source

  • October 31, 2008 at 10:53 am

    #154869

    Is it possible to use a DataReader Destination inside a child Integration Services Package and read the in-memory result inside a parent package with DataReader Source?

    As i see, there is no way to set a package as a source inside a connection manager, right? (I'm not going to write my own Provider, but this could be a way!?)

    I'll go the way by placing the result of my child package to an flat-file or database table to read the result in my parent package if no one can light me a way through the DataReader.

    edit: used for SQL Server 2005

  • November 1, 2008 at 7:46 am

    #892717

    It is not possible to read DataReader Destination in a package. Even if it was possible, it is slower compared to Raw File Source and Destination. We know it because this was our first attempt to create this functionality. Our company CozyRoc have implemented components for exactly this scenario that you need. The components are called: Data Flow Source and Data Flow Destination. They have faster performance compared to Raw File Source and Destination and are not size limited (like them). You can check the following blog post[/url] comparing the performance and you will find there a sample SSIS package, too. These components work for both SQL 2005 and SQL 2008.

    Let us know if you have questions. We will be happy to help.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply