I am looking for a simple way to send a global variable from one DTS package to another (execute the 2nd package through Execute Package Task). then I want to use that global variable that was passed to fill one (of 50) columns in a Transform Data Task

Also is there a way to do a lookup to get a current date to put into 1 column. I have done it through a sql query (getDate()) but I would like to do it without a sql query for ease

Thanks for any ideas. I have looked but haven't found a simple explanation on how to do this.