CREATE PROCEDURE [dbo].[LoadCSVToSatSurveyV2018TempLoad] (
			@Return int out
			)
AS
BEGIN
	SET NOCOUNT ON

	TRUNCATE TABLE SatSurveyV2018TempLoad

SET @Return = -1				--default to error condition unless otherwise overridden

	BEGIN
		INSERT INTO SatSurveyv2018TempLoad
		SELECT *
			FROM OPENROWSET('MSDASQL',
											'Driver={Microsoft Access Text Driver (*.txt, *.csv)}',
											'select * from \\chmohcsystoc\systoc\SqlServerLoad\SatSurveyData.csv')

		DELETE
		  FROM SatSurveyv2018TempLoad

Msg 7399, Level 16, State 1, Procedure dbo.LoadCSVToSatSurveyV2018TempLoad, Line 23 [Batch Start Line 2]
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7303, Level 16, State 1, Procedure dbo.LoadCSVToSatSurveyV2018TempLoad, Line 23 [Batch Start Line 2]
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"

CREATE PROCEDURE [dbo].[Load_SatSurveyV2018Temp_To_SatSurveyV2018] (
			@Return			int out,
			@ClinicID		int
			)
AS
BEGIN
	SET NOCOUNT ON
	SET @Return = -2										--Default to error value

	INSERT INTO SatSurveyV2018 (ClinicID, HashValue, LoadDate, StartDateTime, EndDateTime, CollectionDate, Method, SurveyLanguage, RecommendNPS, RecommendNPSReason, OverallExperience, Comments, CorporateAffiliation,
								VisitType, ListenTo, TreatedWell, EnoughTime, Confidence, MadeEasy, TimelyService, HowDidYouHear, HandHygene, Duration, ContactMe, ContactMethod, ContactPhone,

SELECT *
FROM OPENROWSET('MSDASQL',
				'Driver={Microsoft Access Text Driver (*.txt, *.csv)}',
				'select * from \\chmohcsystoc\systoc\SqlServerLoad\SatSurveyData.csv')

  <system.web>
    <httpRuntime targetFramework="4.5.2" />
    <compilation defaultLanguage="c#" targetFramework="4.6" />
    <trust level="Full" />
    <customErrors mode="On" />
  </system.web>

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>

BEGIN
	SET NOCOUNT ON

	TRUNCATE TABLE SatSurveyV2018TempLoad

SET @Return = -1				--default to error condition unless otherwise overridden

	BEGIN
--use this to load CSV files so we don't limit to 255 characters in a column
		INSERT INTO SatSurveyv2018TempLoad
		SELECT *
			FROM OPENROWSET('MSDASQL',
											'Driver={Microsoft Access Text Driver (*.txt, *.csv)}',
											'select * from \\chmohcsystoc\systoc\SqlServerLoad\SatSurveyData.csv')

		DELETE
		  FROM SatSurveyv2018TempLoad
		 WHERE IDdate = '1/1/1902'

The system has called a custom component and that component has failed and generated an exception. This indicates a problem with the custom component. Notify the developer of this component that a failure has occurred and provide them with the information below.
Component Prog ID: SC.Pool 1 1
Method Name: IDispenserDriver::CreateResource
Process Name: sqlservr.exe
Exception: c0000005
Address: 0X00007FFB18D2137D

Microsoft SSIS Service:
Registry setting specifying configuration file does not exist.
Attempting to load default config file.

public class ToDoExplorerColumnHeadingsOrder
{
    public int DescriptionColumnIndex { get; set; }
    public int ProjectColumnIndex { get; set; }
    public int ModuleColumnIndex { get; set; }
    public int LineNumberColumnIndex { get; set; }
}