Using SSIS to load data from SQL Server to SAP BW

I am wondering why you are planning to opt for SSIS for this. It would not be that easy and compatible. Instead, I will suggest you to for any of the below two options

• Use SAP BW standard anyDB source system
• BO Data services

Both of the options are well compatible and do the data load well and in a native manner.