okay, 1st thing 1st how did you checked that if the SSIS is installed on the Server?

2ndly, create a temporary SSIS package which dump the data from the source to the sql server table see its works or not.

Note: execution should only be done on that machine where this SQLSERVER is installed.

Please do and share your results.