First of all, which version of SSIS?
With procedure, do you mean stored procedure?
1. yes. Depending on the version of SSIS this is easy or rather complicated.
2. yes. Depending on the version of SSIS this is easy or rather complicated.
3. Most likely.
4. Maybe. It depends.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP