155 How to move files to year wise folder in ssis

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 เม.ย. 2024
  • How to move files to year wise folder in ssis
    Download files and scripts: drive.google.com/drive/folder...
    SSIS Tutorials: • SSIS Tutorials
    SSIS real time scenarios examples: • SSIS real time scenari...
    SSIS Interview questions and answers: • SSIS Interview questio...
    How to move files to year wise folder in ssis
    How do I move multiple files in SSIS?
    How do I move files from one folder to another in SSIS?
    How to create a folder dynamically in SSIS?
    Happy Learning.
    If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 6

  • @ahmadserry1823
    @ahmadserry1823 3 หลายเดือนก่อน

    hi sir ,,
    first thanks for all your great videos in sql and ssis
    i want to ask you something
    how can i make a stored proc to check a merge statement
    means i want this stored to check the syntax and the columns that is written right or not
    how can i come up with a logic like this ?

    • @learnssis
      @learnssis  3 หลายเดือนก่อน +1

      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);
      '

    • @ahmadserry1823
      @ahmadserry1823 3 หลายเดือนก่อน

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

    • @learnssis
      @learnssis  3 หลายเดือนก่อน +1

      @@ahmadserry1823 No problem.

  • @AnilYadav-mb4zj
    @AnilYadav-mb4zj 3 หลายเดือนก่อน

    Hi akhil.. I want to contact you how it can be possible

    • @learnssis
      @learnssis  3 หลายเดือนก่อน

      email me at aqil33@gmail.com