Concurrent processing in SSIS – Part 2

Question

Concurrent processing in SSIS – Part 2

Elliott Whitlow

SSC Guru

Points: 102402
More actions
June 24, 2010 at 12:04 am

#222538

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

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

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 More actions · Answer 2

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: 102402 More actions · Answer 3

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: 231 More actions · Answer 4

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 More actions · Answer 5

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")