I want to loop through date said 2000-01-01 to 2000-12-31 and i put the date as variable (said start and stop). I want to recursively call insert query which structured like this:
FOR date in range (start,stop):
INSERT INTO TABLE A (SELECT ...)
ON CONFLICT (CONSTRAINT)
DO UPDATE (...)
WHEN
DATE + INTERVAL 1 DAY
I wonder if i can use SSIS Loop container and loop through day using this.



