Tempdb is one of the system databases in SQL server 2005, more or less similar to any other user database except that the data stored in the tempdb got lost after shutting down the SQL server service.
Each time the SQL server service starts, the tempdb is newly created by copying from model database (another system database) and inheriting some database configuration from it.
There may be some circumstances in a sanctuary where it becomes necessary to keep a leash of foxes and a pack of wolves separate so that they must not fight with each other and make things a mess. Similarly, in the database jungle we do the same things by using some conditional statements in order to keep things distinct. SSIS provides a nice transformation to do the same, i.e. Conditional Split Transformation.
By using this conditional split transformation, the incoming data can be split into multiple outputs as per the conditions specified. It has a default output too that handles all the rows that do not match to any conditions.
Don’t have an account? Create one, its simple
Recent Comments