Concurrent processing in SSIS – Part 2

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    Comments posted to this topic are about the item Concurrent processing in SSIS – Part 2

  • SQLRNNR

    SSC Guru

    Points: 281252

    Thanks Elliott - nice article.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • wilisyygopper

    Grasshopper

    Points: 15

    There are many good information and details so I hope you will read care fully and take more information ...

    Cho Yung Tea

    Force Factor

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    Thanks Jason. I'm not sure what to think about the near lack of discussion on the first part and effectively no discussion on this part..

    I'd like to think it was THAT good, but I was thinking there would be more discussion..

    CEWII

  • Aaron-254516

    SSC Veteran

    Points: 201

    Hi Elliott,

    The article was indeed THAT good. I found it a few months ago and have finally been able to implement it in a project that I have duplicate data flow tasks in.

    I've been trying to adapt my VS2013 SSIS project to the ParentSingleChildScriptMethod.dtsx. However it seems that using this method, the SingleChild.dtsx must be self contained. What I mean is that it can't use Project Connection Managers or Project Caches? The SingleChild.dtsx has to be able to function independently?

    Thanks for any comments or additional information,

    Aaron

  • DC_07

    SSC Enthusiast

    Points: 171

    Hi,
    Regarding the example Parent Child Using script method
    How would you replace this code to call the child package inside the project (that willbe deployed to ssis catalog) rather than the file system like in the example

    'We have some work to do so we'll do it.
    _oInstance = New Instance(CInt(Dts.Variables("MaxWorkerThreads").Value), _
    "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\", _
    "C:\Temp\Multi_Run_Sample\SingleChild.dtsx")

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

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