Database

Create Procedure sp_CheckDate (@ID int)
As
DECLARE @Today datetime
    SET @Today = GetDate()
    
    Select
        Case
            When @Today Between DateColumn1 And DateColumn2 Then 
                CAST(1 As bit)

            Else 
                CAST(0 as bit)
        End As Result
    From
        TableName
    Where
        IDColumn = @ID

Function sp_CheckDate(connection, ID)
Dim strSql, rst
On Error Resume Next
    strSql = "sp_CheckDate (" & CLng(ID) & ")"
    Set rst = connection.Execute(strSql)
    If rst.Eof Then
        'ID not found, or there was an error
        sp_CheckDate = False
    Else
        sp_CheckDate = CBool(rst.Fields(0).Value)
    End If
    rst.Close
    Set rst = Nothing
End Function

bool sp_CheckDate(SqlConnection connection, int ID)
{
    SqlCommand command = connection.CreateCommand();
    command.CommandText = "sp_CheckDate";
    command.CommandType = CommandType.StoredProcedure;
    
    SqlParameter p = command.Parameters.Add("@ID", DbType.Int32);
    p.Value = ID;

    try
    {
        object ret = command.ExecuteScalar();
        
        if (ret is bool)
            return (bool)ret;
        else
            // ID not found
            return false;
    }
    catch (SqlException ex)
    {
        // Some other error
        return false;
    }
}

1. Open up SQL Server Enterprise Manager.
2. Right-click on the target database, and choose All Tasks -> Import Data.
3. For the source, choose Text File, and select your text file.
4. Follow the instructions to set up the import.
5. In the final screen, select Scheduled DTS package for later execution, and click on the "..." button to set up the schedule.