<div>
You should be able to use a ForEach File Loop, using something like file_name_here.*, capturing the return file name, and process accordingly.
</div>


You should be able to use a ForEach File Loop, using something like file_name_here.*, capturing the return file name, and process accordingly.

<div>
Jim actually file name for those files is same only extensions are different some thing like this test.txt1,test.txt2,test.t<wbr />xt3
</div>


Jim actually file name for those files is same only extensions are different some thing like this test.txt1,test.txt2,test.txt3

<div>
I can accomplish this using batch file
</div>


<div>
<div class="content wysiwyg-content">
I have bunch of files that I need to copy,but issue is that the file name is same but extensions are something like this .txt0,.txt1,.txt2 etc. So how can I create a SSIS package that could loop through these files and copy these files?
</div>
</div>


I have bunch of files that I need to copy,but issue is that the file name is same but extensions are something like this .txt0,.txt1,.txt2 etc. So how can I create a SSIS package that could loop through these files and copy these files?

SSIS-Copy files

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.