I have built a package of 9 transformations in SS2K. I am doing a couple
of tasks up-front, naming variables, etc., and then I want the transforms
to fire afterward (once I've provided the filenames to each transform).
When I go to set up my workflows, I can set them up between my ActiveX task
and my Dynamic Properties task, and to one of the transformations; however
I apparently cannot control the sequence of the transformations. I get an
error when I try to connect two transformations: "Defining precedence
between the selected items is not valid".
Since the tables are related, I need the data to come in in a certain
order. I can't have all the transformations happening at the same time.
Am I doing something wrong, here? How can I specify workflows from
transform to transform?