Easiest and reliable way is to Generate scripts and save to a single sql file. one other way for ssis is use a Execute SQL task and write a query to pull all the data and save it to a file. To automate a process for backing up the whole database I would go with SSIS, but not this one I believe.