SSIS Code - Check URL Exists using C# Script - 404 Error

In this post you will learn how to use SSIS Script Task (C# Code) to detect specific URL found or not (Detect HTTP 404 Error)

If you using SSIS JSON Source or our REST API Task then if URL/Document you trying to read not found then server may return 404 (Not Found) Exception. In order to handle this error gracefully you can use following Script to store status in a variable and then you can use conditional Control Flow to Skip data loading from Web Service.

Step1: Drag Script Task from toolbox
Step2: Select Language as C#
Step3: Select Readonly variable (In this case “User::url” – String Type)
Step4: Select ReadWrite variable (In this case “User::found” – Boolean Type)
Step5: Edit code and paste following script in your script task

SSIS C# Code – Check URL Exists (Catch 404 Not Found Error)

Contents hide

1 C# Code: Check URL Exists (Detect 404 Error)

1.1 More from ZappySys Blog

C# Code: Check URL Exists (Detect 404 Error)

	public void Main()
	{
		// TODO: Add your code here
            Dts.Variables["found"].Value = UrlFound(Dts.Variables["url"].Value.ToString());
		Dts.TaskResult = (int)ScriptResults.Success;
	}

        private bool UrlFound(string url)
        {
            try
            {
                var request = WebRequest.Create(url);
                var response = request.GetResponse();
                return true;
            }
            catch (WebException we)
            {
                HttpWebResponse errorResponse = we.Response as HttpWebResponse;
                if (errorResponse != null)
                    if (errorResponse.StatusCode == HttpStatusCode.NotFound)
                    {
                        return false;
                    }
                    else
                        throw; //we only look for 404 Error
            }
            return false;
        }

public void Main()

{

// TODO: Add your code here

Dts.Variables["found"].Value = UrlFound(Dts.Variables["url"].Value.ToString());

Dts.TaskResult = (int)ScriptResults.Success;

}

private bool UrlFound(string url)

{

try

{

var request = WebRequest.Create(url);

var response = request.GetResponse();

return true;

}

catch (WebException we)

{

HttpWebResponse errorResponse = we.Response as HttpWebResponse;

if (errorResponse != null)

if (errorResponse.StatusCode == HttpStatusCode.NotFound)

{

return false;

}

else

throw; //we only look for 404 Error

}

return false;

}