155 How to move files to year wise folder in ssis 

I have never tried it, can you take help from chatgpt on it, it can give you syntax. When I asked it has given me this sp, if you got any issues, give the code to chatgpt and ask to fix it. CREATE PROCEDURE CheckMergeSyntax @mergeStatement NVARCHAR(MAX) AS BEGIN SET NOCOUNT ON; BEGIN TRY -- Attempt to parse the MERGE statement to check syntax DECLARE @dummy INT; SET @dummy = PARSE(@mergeStatement AS SQL); PRINT 'Syntax check passed.'; END TRY BEGIN CATCH -- If an error occurs, print the error message PRINT 'Syntax check failed. Error: ' + ERROR_MESSAGE(); END CATCH END; ------------------ EXEC CheckMergeSyntax ' MERGE INTO TargetTable AS T USING SourceTable AS S ON T.ID = S.ID WHEN MATCHED THEN UPDATE SET T.Value = S.Value WHEN NOT MATCHED THEN INSERT (ID, Value) VALUES (S.ID, S.Value); '

@@learnssis thank you so much for your help sir shoukrya

@@ahmadserry1823 No problem.

email me at aqil33@gmail.com