Parallel Processing In SSIS

Keshav Singh

Rate me:

4.17/5 (6 votes)

21 Dec 2011CPOL

23.2K

This video shows the essence of parallel processing in SSIS.

While this video does not appear under "Videos" in the profile tab, it is part of videos on The Code Project. If you are interested in hosting a video on a coding solution on Code Project, email us at submit [at] codeproject.com.

This video shows the essence of parallel processing in SSIS. It is actually a POC that I had undertaken for 4 scenarios to find which scenario would help me get the optimum performance. I really wanted to share and help SSIS guys understand MaxConcurrentExecutables property and benefit from it as and when they can.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Keshav Singh

Database Developer

India

I am a Microsoft certified Technology Specialist in MS SQL Server 2008 and 2005.I have fair amount of experience and expertise in MS database development, administration and modeling and MS BI. Started my career in 2007 and primarily into MS databases, and later diversified into MS BI especially SSIS. I also have a little exposure in Oracle 10g while working on one of the migration projects. But MS SQL Server is my passion!

Firm believer in knowledge grows from sharing, I really like reading books, trying new features and sharing the little that I know. Unless we're willing to have a go, fail miserably, have another go, success won't happen. The best thing I have discovered about myself is the "never say die" attitude. The best comment I have ever received is when my manager at my first job said "when this guy works he throws away his watch".

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Parallel Processing In SSIS

License

Comments and Discussions