Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Anyone deeply understand the BufferWirePacket of PipelineBuffer?

Unanswered Anyone deeply understand the BufferWirePacket of PipelineBuffer?

  • Thursday, January 24, 2013 4:53 AM
     
     
    Sign In to Vote
    0

    Hi All,

    To most of my customers, SSIS is too heavy to use. So I'm writing my own Integration Services based on my understanding of SSIS and using Silverlight as its UI.

    The progress is good currently, but I met some design problems, the most critial one is how to understand the role of BufferWirePacket in PipelineBuffer Constructor and how MS realize this under that IntPtr.

    MSDN only provides the following article for this:

    http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.pipelinebuffer.pipelinebuffer(v=sql.110).aspx

    But it doesn't constain enough useful message for "BufferWirePacket", because it's "IntPtr", but I really believe it's the core of the magic of SSIS, it helps PipelineBuffer to control the producers-consumers model.

    Anyone can help me?

    Regards, Nighting Liu

     

All Replies

  • Thursday, January 24, 2013 2:45 PM
     
     
    Sign In to Vote
    0
    Anyone from Microsoft can help me, or this COM+ interface is a secret?

    Regards, Nighting Liu

     
  • Friday, January 25, 2013 5:44 PM
     
     
    Sign In to Vote
    0

    Hi, cannot find more information about the BufferWirePacket parameter of  PipelineBuffer Constructor on the Internet. The related MS document is not detailed enough...

    Regards, Leo

     
  • Friday, January 25, 2013 5:56 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi All,

    To most of my customers, SSIS is too heavy to use. So I'm writing my own Integration Services based on my understanding of SSIS and using Silverlight as its UI.

    The progress is good currently, but I met some design problems, the most critial one is how to understand the role of BufferWirePacket in PipelineBuffer Constructor and how MS realize this under that IntPtr.

    MSDN only provides the following article for this:

    http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.pipelinebuffer.pipelinebuffer(v=sql.110).aspx

    But it doesn't constain enough useful message for "BufferWirePacket", because it's "IntPtr", but I really believe it's the core of the magic of SSIS, it helps PipelineBuffer to control the producers-consumers model.

    Anyone can help me?

    Regards, Nighting Liu

    I think your intent is to compete with Microsoft in the ETL services, do not take me wrong, but as a for profit company, why would anybody from Microsoft be interested in spending their effort and time on your request? I think it is too naive to post questions like that in a MSDN forum.

    PS: I do not understand what is "too heavy"? SSIS is based on in-memory processing, you can use any technology to achieve this, e.g. in .Net there are in memory structures, files, etc.

    Arthur My Blog