How to Develop SSIS Project Solution from Zero to Crystal Clear Architechture

Hi folks after visiting and looking in cloud of internet for developing SSIS solution from scratch, I didn’t find any proper link.

I would like to provide a new idea towards the success of Best Complete SSIS architectural Solution.

So here is tips/Steps towards same .

Step 1 ::Collect all terms,processes,databases,user,handlers,Agent that are going to participate in your system or SSIS solution

Example :Here am going to explain you by one of current BI project Architecture Development .

Project requirement id to have 6 processor i.e. Batch job process which can run at run time as well through Scheduling and with lots of addition functionality.So i started my research based on that.

Due to Security  i am not able to provide you all the details of my project but  you can recognise all the things for sure.

So i just go on writing all the project component on the notes as show in following diagram in any order.


SSIS Identification By Component
SSIS Identification By Component

SSIS Architecture

Note down all Process/component by random thought and then convert those notes to required process  

 Step 2 ::Group Component By processes,Application,Database as look sites at right position in architecture

Example :Yes ,After collecting all notes group them in following structure :

  • By Process
  • By User
  • By Database
  • By Sequence
  • By Similar Component

 Use As i have shown in the diagram


Group By Process/Task/Similer Component
Group By Process/Task/Similer Component

 Here is magic convert all your thoughts to note and note to Proper flow and Proper Flow to Actual Architecture.

And After that it just how you are expert with Visio to actual Architecture diagram.

as shown following

Architecture in SSIS
Architecture in SSIS


So just Dont get panic with big SSIS architectural it just form with above simple steps.

If you want some more Details then let me know geeks .


3 thoughts on “How to Develop SSIS Project Solution from Zero to Crystal Clear Architechture

  1. Nope This Architecture is not Fixed it is Based on How you are going to Use your Processor Or You can say Dependecy of your Processor.

    And this is just one way to form any architechture and all Processor information is Based on Your Actual Development towords each solution.

    I will update more detail in upcoming section.

    Pleses subscribe blog if you want dear for more updation.


  2. hi,
    is this architecture fixed for all SSIS project or it differs depends on our projects?
    can u give some information how exactly processors ie.1,2,3,4,5,6 works?
    can u give some more information?


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s