SED Replace String Help

I have to replace date in Control file every day i run the script
control file looks like this

$cat pharma.ctl
LOAD DATA
INFILE '/usr/bin/sqlscripts/SQL.PharmID.20071206.txt'
INTO TABLE uname.TEMP_TABLE
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(col_names)

i tried
$sed -e s/SQL.PharmID.[0-9]*.txt/SQL.PharmID.`date +%Y%m%d`.txt pharma.ctl>pharma.ctl
Command Garbled

can someone give me the right command

DD=SQL.PharmID.`date +%Y%m%d`.txt
echo $DD
sed -e 's/SQL.PharmID.[0-9]*.txt/'$DD'/g' CONTROLFILE.ctl > CONTROLFILE.ctl.new

Hi,

sed "s/SQL\.PharmID\.[0-9]*/SQL\.PharmID\.`date +%Y%m%d`/" filename