I have a problem with transformations and adding/removing fields in the database. If a create my transformation which takes about an half-hour, go back into my database and delete a field, go back to my transformation, ALL my fields have shifted and are not correctly aligned. I have tested it by creating the transformation, deleted a field in the database that i don't want to use, and when i go back to the transformation, all of the fields are miss-aligned. I can't imagine spending the time of creating transformations, adding/deleting fields in the database and having to start all over again in the transformation. What am I doing wrong?
Mark
