SQLTeam.com | Weblogs | Forums

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?