SQLTeam.com | Weblogs | Forums

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


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


How about using a Data Flow task instead?