This task has a number of data dump and data retrieval functions and can be added to any package.
You can provide information for the necessary fields directly in the Microsoft SQL interface or by script using ModifyScript.
MODIFYSCRIPT Package Variable (DumpLoad)