Database

<br />
-- create the test table<br />
create table t1(ID int, date1 datetime, date2 datetime)<br />
<br />
-- insert test rows<br />
insert into t1 (ID, date1, date2) values (1, '15 Jan 2001', '20 Feb 2003')<br />
insert into t1 (ID, date1, date2) values (2, '01 Sep 2000', '19 Apr 2001')<br />
<br />
-- drop the proc if it exists<br />
if object_id('sp_CheckDates') is not null drop procedure sp_CheckDates<br />
go<br />
-- create the proc<br />
create procedure sp_CheckDates @ID int<br />
as<br />
declare @Date1 datetime<br />
declare @Date2 datetime<br />
select @Date1 = date1, @Date2 = date2 from t1 where ID = @ID<br />
<br />
if @Date1 is not null and @Date2 is not null begin<br />
	if datediff(dd, @Date1, getdate()) > 0 and datediff(dd, @Date2, getdate()) < 0 begin<br />
		print 'Bingo!'<br />
		return 0<br />
	end else begin<br />
		raiserror ('Date not in specified range', 16, 1)<br />
		return 1<br />
	end <br />
end else begin<br />
	raiserror('Specified ID does not exist.', 16, 1)<br />
	return 1<br />
end<br />
go<br />
<br />
-- test execution<br />
exec sp_CheckDates @ID=1 <br />

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.