Phil, I put a messagebox in script component in dataflow, and the values is set, but for some reason its lost once it come of that dataflow. I checked the...
As you suggested, i can run one after another. how can i make it a automatic process? create one ETL package for each aplication and then create a another package...
Thanks for your reply. I don't think i understand your answer. I am new to BIDS and learning righrt now. I would apprecite if you could explain it little bit...