run both.

SELECT * 
FROM sys.objects 
WHERE name = 'fn_syspolicy_is_automation_enabled' AND type = 'FN';


SELECT msdb.dbo.fn_syspolicy_is_automation_enabled() AS IsAutomationEnabled;

• This reply was modified 10 months, 3 weeks ago by Tav29.

launch Sql Server Configuration Manager, Do you see SQL Agent running?

Your are correct regarding "Data for 2024-02-29 is left in place until 2027-03-01."

Good point Phil. I do believe DATEADD(year, -3, GETDATE()) Takes leap year into account, I'm too lazy to load test data. also I would not delete data from a table...

• This reply was modified 10 months, 3 weeks ago by Tav29.
• This reply was modified 10 months, 3 weeks ago by Tav29.

You can add to your SP after records are created or execute another SP that deletes the records over 3 years old. You need to have a date for when...

a simpler way is to run Powershell Script:CheckforSameFileNames.ps1 before processing files

Script Code below

Set-ExecutionPolicy -ExecutionPolicy Unrestricted -Scope CurrentUser
Write-Host "Execution policy set to Unrestricted for...

• This reply was modified 11 months ago by Tav29.
• This reply was modified 11 months ago by Tav29.
• This reply was modified 11 months ago by Tav29.
• This reply was modified 11 months ago by Tav29.
• This reply was modified 11 months ago by Tav29.
• This reply was modified 11 months ago by Tav29.

https://stackoverflow.com/questions/6598139/how-to-loop-only-through-files-that-dont-exist-in-destination-using-an-ssis-pac?rq=4

What helps me, I would flowchart the entire process and  then create your SSIS Package.

• This reply was modified 11 months ago by Tav29.

Couldn't you check if the file exists In the destination folder first and  if so move to unproccessed folder and then continue processing the next file?

• This reply was modified 11 months ago by Tav29.

This might help: https://stackoverflow.com/questions/30498478/ssis-change-date-add-local-timezone-in-data-flow

Yes, I searched and came across "Jeff Moden's infamous delimitedSplit8K function". I was looking for an alternative way.  I will implement Jeff Moden's infamous delimitedSplit8K function.  Thanks for the reply.

Correction I need help with also the first name because I'm getting the middle Initial in my first name results;Example First Name Results= John J

Hey Phil,

You are correct had 30,000+ records with the word "Responsibility" misspelled and 400+ spelled correctly.  Ran replace function to correct the misspelling.

SELECT Pos1 = CHARINDEX('Total Paid amount is $',...

• This reply was modified 4 years ago by Tav29.

Fixed. Absolute Value (ABS)

Phil,

I'm getting this error. Here is my sql statement:

SELECT Notes, NoteId

,TotalPaid = SUBSTRING(Notes, c.Pos1, c.Pos2 - c.Pos1)

FROM dbo.NoteReceive

CROSS APPLY

(

SELECT Pos1 = CHARINDEX('Total Paid amount...

Never mind Phil, I got it. Thank you for your help.  also thank you Jonah.