I wanted to learn and create an SSIS package which will run on a scheduled basis. In a nut schell what the package will do (in sequence)...
1.0 Check for date
2.0 Run Procedure 1
3.0 Log Procedure 1 output summary or error/s
4.0 Run Procedure 2
5.0 Log Procedure 2 output summary or error/s
6.0 Run Procedure 3
7.0 Log Procedure 3 output summary or error/s
8.0 Clean Temporary tables created by Procedure 1, 2 & 3.
Can anyone show me where to begin or at least sites where i could learn it from scratch.