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.
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
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
If you want some more Details then let me know geeks .