DTS script task has encountered an exception in user code, cannot load script for execution

1

Hello i am trying to use Script Task in SSIS to transfer data from Excel file to SQL sever, and i am getting the above error, please help

2

How about using a Data Flow task instead?