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
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 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
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
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
did you create any video on this , Please share the link with me
@@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
@@learnssis Can you please create the video , if possible
@@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.