We all know about the Control Flow tasks for the three containers (For Loop Container, Foreach Loop Container and Sequence Container): Are you aware that there is a 4th container that you can't see in the list of tasks? It is called the Grouping Container. What you see below is some script tasks that I have pulled out to my control flow. If you would like to put them into a Grouping Container, all you would have to do is highlight those tasks: Then Right Click and select Group. This is great for...
Read More
Below is an example of creating a table and setting it up to automatically generate a unique identity for each record entered. The first column is the CustomerID. In between the parenthesis you see (1,1). We are setting up the first record entered to start off with a CustomerID of 1. We are also saying that every recorded entered after that should have a CustomerID that increments by 1. So, obviously the next record that gets entered will be 2, then 3, so on and so forth. We now are adding recor...