Bulk Rename File Extension

Advanced SSIS File System Task is designed to full fill most common file system related operations in SSIS. Native SSIS File System Task provided by Microsoft lakes many useful features (e.g. copy/move/delete/rename multiple files, search/replace etc).

Features

  • File operations for single or multiple files using wildcard(e.g. copy, move, rename, delete, write to file, get properties)
  • Folder operations such as delete folder and create folder
  • Support for bulk rename (e.g. by specifying {%name%}.{%ext%}.old as new name will rename all selected files to *.old)
  • Search and Replace in files (Regular expression search supported)
  • Change file encoding
  • Get file properties as data table which you can loop easily (Using ForEach Loop – ADO Enumerator)
  • Option to continue on error (e.g. Copy file only when source file found)
  • Auto create missing target directory
  • Use placeholders anywhere in the path, makes it easy to timestamp folders or files (e.g. c:Archive{{System::StartTime,yyyMMdd}})
  • Regular Expression based Include Pattern (e.g. ^(filedd).(w+)$ will include file01.exe,file22.csv …)
  • Regular Expression based Exclude Pattern (e.g. (.exe .msi) will exclude files with extension exe or msi)
  • Sort based on specific property (e.g. Order Size DESC – extract top 10 files by size)
  • Advanced SQL like filter support (e.g. Size> 1024 AND AgeInDays > 10 AND Extension IN(‘.txt’,’.csv’) will include file greater than 1024 bytes and extension is txt or csv)
  • Support for Regular Expression based Include Pattern (e.g. ^(Customerdd).(w+)$ )
  • Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory

JSON File Destination
JSON Generator Transform
Web API Destination
Export JSON File Task
REST API Webservice Task
XML Source Connector (File, SOAP, REST API)

To batch rename files, just select all the files you want to rename, press the F2 button (alternatively, right-click and select rename) and then enter the name you want and press the enter button. What the above action does is take the file name you specified and adds a number to each file name. Finally, click Rename button to almost instantaneously rename the file(s). The Replace feature of the application lets you replace a certain part of the file name. Similar to the aforementioned rename command, you need to put original and new text under Find and Replace With headings to replace that particular string. However, this feature is a.

In Visual Studio, drag and drop the Advanced File System Task in the design surface from SSIS Toolbox.

Bulk Rename File Extension

In Visual Studio, drag and drop the Advanced File System Task in the design surface from SSIS Toolbox.

How to Copy Multiple Files (Use wildcard)

Advanced SSIS File System Task – SSIS Copy Multiple Files (Use wildcard)

How to Delete Multiple Files (Use wildcard)

Advanced SSIS File System Task – SSIS Delete Multiple Files (Use wildcard)

How to Delete files older than X days – Advanced Sorting and Filtering

Rename File Extension In Bulk

Advanced SSIS File System Task – SSIS Delete files older than X days

How to Rename Multiple files (Use wildcard pattern)

Advanced SSIS File System Task – SSIS Rename Multiple files (Use wildcard pattern)

How to Search and Replace multiple files (Extended mode and Regular Expression Support)

Advanced SSIS File System Task – SSIS Search and Replace multiple files (Use wildcard pattern)

How to check file exists (check for single or multiple files)

Advanced SSIS File System Task – SSIS check file exists (check for single or multiple files)

How to change file encoding (to UTF8, UTF16 or ASCII)

Advanced SSIS File System Task – SSIS change file encoding (to UTF8, UTF16 [UNICODE] or ASCII) (single or multiple files)

How to get sorted file list and loop through it

Advanced SSIS File System Task – SSIS get sorted file list and loop through it

Bulk Rename File Extension

How to create new file and write text to it

Advanced SSIS File System Task – SSIS create new file and write text to it

Bulk rename file extension

Articles / Tutorials

SSIS PGP Encryption / Decryption (Using FREE GPG Tool)

Introduction In this new article, we will show you how to perform PGP encryption using SSIS (encrypt / decrypt files using public / private key). Our previous article was about SFTP using our SFTP task for SSIS. Now we will show how to encrypt the information. Requirements First of all, you will need SSDT for Business Intelligence for […]

Calling SSRS Reports in SSIS (Export / Email)

Introduction about calling SSRS Reports in SSIS Calling SSRS Reports in SSIS is straightforward using the ZappySys Reporting Services task. Also, we will show how to export files SSRS files using SSIS, how to send reports in emails and how to send parameters. In addition, we will be using this ZappySys SSIS PowerPack component to make things work: […]

How to read and write data to HTML in SSIS

Introduction to read and write data to HTML in SSIS In this article, we will show how to send values from an SSIS Variable to an HTML file. We will use the SSIS Advanced File System Task to store the list of system files of a folder into a variable and then we will use […]

Using Regular Expressions in SSIS

Introduction In this short article you will learn how to write Regular expressions in SSIS (i.e. Regex) and what tool to use to test them. You will also find helpful resources on how to write more sophisticated expressions and learn more about them. For demo purpose we will use FREE SSIS Regex Parser Task to parse and […]

How to remove invalid characters from XML using SSIS and Regex

 Introduction In this blog post you will see how to remove invalid characters from XML using SSIS. We will use search and replace feature of Advanced File System Task. Remove Invalid characters from XML Xml file specification have restriction about which characters can be part of XML data and which should be avoided. If you use […]

SSIS check file is locked and wait until file is unlocked (C# Script)

Introduction In this small blog post you will learn How to move files using SSIS Advanced File System Task and How to wait until file is unlocked using C# Script Task. How to check if file is locked (SSIS C# Script Task) If you want to check if file is locked in C# then below […]

Get list of files in SSIS for Looping

Introduction In this post you will learn how to use Advanced File System Task to get list of files and folders into variable. Advanced File System Task is significantly better than native SSIS File System Task How to get list of files in SSIS Most simplest way to get list of files in SSIS is […]

Search and replace in files using SSIS – No Coding

Introduction Many times you have requirement to search and replace in files (single or multiple file) content using SSIS. If you are not C# or VB.net programmer then you may find yourself at dead end struggling how to achieve this in SSIS. If you have this need then you can use Advanced File System Task […]

How to change file encoding in SSIS (UTF8, ASCII or UTF16)

Introduction Many times during your ETL process you receive files which are in different encoding than you expect. Example all files are in UTF-16 format but your application expect them to be in UTF-8. Or Sometimes files are in ASCII format and you want to convert to UTF-8. In this post you will see how […]

See Also

Click here to learn more about System Requirements

Sometimes we work on tasks where a ton of pictures need to be uploaded but the catch lies in the presence of file extensions of many types.

Renaming files is a pretty straightforward task in all versions of Windows. Windows 10 has made it even easier by allowing a details preview on the right-hand side of the screen when a file is selected. However, renaming file extensions is almost impossible unless you’re a real geek.

Renaming file extensions/ filenames is a pretty easy task courtesy the powerful renaming artery you can unlock once you install Easy File Renamer onto your computer. It is an absolutely straightforward task, and is described in more details in the passage below. However, be sure to create a backup for any files that you are going to change the file extensions for, as this operation often renders the files completely useless.

Easy File Renamer is a digitally signed, verified software

Rename File Extensions

As earlier stated, Windows 10 or any Windows for that matter, doesn’t allows users to change the file extension. In order to do so, you need to perform a procedure that is somewhat trickier than simply renaming a file by pressing the F2 button and typing in the new name.

  1. Rename Extensions through File Explorer

    Windows 10 provides a very handy menu that provides options to change settings that relate to the manner in which the user can view folders and a huge array of associated functionalities. You can enable the rename file extension option by going to the Folder Options window.

  • Click the View button on the top menu in the folder where you intend to rename extensions.
  • At the far end of the View menu, locate and click the Options button.
  • Click the View tab.
  • In the Advanced settings area, uncheck the checkbox for Hide extensions for known file types.
  • Click ApplyOK.

Batch File Rename Windows 10

  1. Now press F2 in the folder where the target data is located and the extensions will become visible now. Even though you can rename any extension you want, bear in mind that this renders the file unusable in most cases. So it’s always advisable to create a backup of the data before you proceed ahead, in case things go wrong while you’re renaming extensions.
  2. Rename Extensions through Easy File Renamer

Another option you have at hand is to change the extension of the file through a software. There are multiple options available on the web to aid you in doing so, amongst the more renowned ones is Easy File Renamer. Just download the software, install it and follow the steps given below.

Bulk Rename File Extension
  • Add the target files/ folders from the Step 1 section.
  • In the Step 2 drop-down menu, select New Name.
  • You will notice another drop-down menu that just popped up just below the Name textbox in Step 2. Click that drop-down menu and select Extension.
  • Now type in the new extension of your choice in the Name textbox.
  • Click Add Rule and then go for the green Rename button at the far end of the screen.
  • Click Yes to initialize the process.

Be advised that changing file extensions often results in the original file being rendered useless. Therefore, it is highly recommended to undertake some hefty research over the Internet about file types which aren’t affected by any extension related migration. Also, create a backup before you undertake the operation of changing the extensions. This helps guard against any unforeseen eventualities.

Rename Filenames

Bulk Rename Utility File Extension

If you simply are in need to renaming a reasonably sized selection of filenames, you can easily do so manually by performing the ages old procedure of renaming a file by selecting Rename from the context menu or you can simply select the file, press F2 and press Enter once you’ve typed in the new filename.

However, if you’re faced with the task of renaming hundreds (or even more) files, it is always a good idea to bank on an automated solution to save time, guard against fatigue and most importantly for the sake of minimizing the risk of human error. Here is how you can do so within minutes:

Windows Bulk Rename File Extension

  1. Download and install Easy File Renamer.
  2. Launch the software and select Folders in Step 1.
  3. Now click the Add Folders button which is located underneath, select the target folder(s) and finally click Add Folder.
  4. Select the renaming rule(s) of your choice from the Select Rule dropdown menu in Step 2. Some rules provide additional textboxes for you to enter text that might be required. e.g. the Find and Replace textboxes in Replace Text.
  5. Click the Add Rule button which is located right under the above mentioned textboxes.
  6. Click the Rename button in the bottom-right corner of the screen.
  7. Select Yes in the prompt to signal your approval.