160 How to rename all files from a folder using ssis

Поделиться
HTML-код
  • Опубликовано: 21 окт 2024

Комментарии • 6

  • @Ankit_Gurjar_1997
    @Ankit_Gurjar_1997 4 месяца назад +2

    Dear Akhil Sir,
    I appreciate your video demonstration. In the folder, there are currently three files:
    Email.csv
    Employee.csv
    Student.csv
    We need to ensure that any additional CSV file added to this folder, such as "Product.csv", is not renamed , Means "Product.csv" Should be Not be Renamed , Only we want to Rename Specific File in One Folder

    • @learnssis
      @learnssis  4 месяца назад +1

      If you do not want to rename a specific file, then before the File System Task, you can put a data flow task, and connect the data flow task with the File System Task. Now on the expressions between data flow task and File System Task, select Expressions, and write the expressions there
      Just drag and drop the FileName into the expression windows and write condition
      @Filename != "Product.csv"
      And then save the changes.
      I have written @FileName but here you would need to drag and drop the FileName ssis variable. Now what will happen the File System Task will only get executed if the file name is not Product.csv

    • @Ankit_Gurjar_1997
      @Ankit_Gurjar_1997 4 месяца назад +1

      did you create any video on this , Please share the link with me

    • @learnssis
      @learnssis  4 месяца назад +1

      @@Ankit_Gurjar_1997 If you look at this video, I have used the expressions here to decide whether to execute the next task or not.
      ruclips.net/video/OklmSWn3qso/видео.html

    • @Aarav_Gujjar_Vlog
      @Aarav_Gujjar_Vlog 2 месяца назад +1

      @@learnssis Can you please create the video , if possible

    • @learnssis
      @learnssis  2 месяца назад +1

      @@Aarav_Gujjar_Vlog Give my code to chatgpt, and ask it to make the changes to code and give the requirement it can write the code as per requirement.