160 How to rename all files from a folder using ssis

Поділитися
Вставка
  • Опубліковано 25 січ 2025

КОМЕНТАРІ • 6

  • @Ankit_Gurjar_1997
    @Ankit_Gurjar_1997 7 місяців тому +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  7 місяців тому +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 7 місяців тому +1

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

    • @learnssis
      @learnssis  7 місяців тому +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.
      ua-cam.com/video/OklmSWn3qso/v-deo.html

    • @Aarav_Gujjar_Vlog
      @Aarav_Gujjar_Vlog 5 місяців тому +1

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

    • @learnssis
      @learnssis  5 місяців тому +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.