BULK INSERT SQL

    DECLARE @datefile varchar(50)
    DECLARE @PATH varchar(100)
    DECLARE @query varchar(max)
    DECLARE @err_message varchar(100), @checkDate VARCHAR(max)
    SET @datefile = CONVERT(date, getdate()-2) --Get Current Date




 
    --CONVERT(VARCHAR(10), Created_Time, 120) --> Get Only Date

    SET @checkDate = (SELECT DISTINCT  CONVERT(VARCHAR(10), Created_Time, 120) AS dateTable from TABLE_NAME
    WHERE CONVERT(VARCHAR(10), Created_Time, 120) = @datefile)
    BEGIN
    IF LEN(@checkDate) IS NULL --Check If Date Not Exist In Table
    BEGIN
    SET @query = 'BULK INSERT TABLE_NAME
                    FROM "D:\PATH\TO\FOLDER\'+@datefile+'-FileName.txt"
                    WITH
                    (
                        FIELDTERMINATOR = ''\t'', -- TAB SEBAGAI DELIMITER FILE
                        ROWTERMINATOR = ''\n'',
                        FIRSTROW = 4   ---START PADA ROW KE - 4
                    )';
    exec(@query)
    END
    ELSE
    BEGIN
    SET @err_message = 'DATA ALREADY EXIST'
        PRINT (@err_message)
    END
END