Yes, you are correct that the database name would be left blank if you're using a variable.
Can you check the SourceConnection to make sure you have a valid source specified?
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices