Yes, SSIS does not have any requirements as far as what tasks you use. We have a few packages that do nothing but call stored procedures and run VB script tasks. It was just easier to wrap them in a package than compiling an executable.

If you are going to run an update on the second DB, write a simple stored procedure with a parmater. It will be easier to maintain down the road and not require any changes to the package.