You definitely need to lose the quotes around '$CSVfile'. Additionally, note that unless the filename includes an absolute path (e.g. starts with a volume letter or a slash),
DBD::CSV will assume that the file is in the f_dir directory which defaults to whatever the script assumes is the current working directory. Check to make sure that you are in the directory you think you are and explicitly set f_dir if you aren't.