Found a great post on adding meta tags to a MOSS site. Followed the instructions on the post and it works great!
Downloaded MetaTagger.wsp, copied it to c:\sharepoint\metatagger and ran the following
Stsadm -o addsolution -filename c:\sharepoint\metatagger\metatagger.wsp
Then went to Central Admin – Solution Management
Clicked Deploy Solution
Selected the web application