Blog Detail

SQL SERVER SSIS: Get File Name with Flat File Source, Data Flow Component
12 Apr 2010
Tejas Shah
/Project/ImageURL/2)Derived FileName Show Advanced Editor_thumb[3].jpg
As I explained earlier about For Each Loop Container, which process each file from selected folder.

There is a requirement to save File name along with record, so later on we can identify which record comes from which file.

Let me explain it how to achieve with FileNameColumnName property of Flat File Connection to get it easily.

1. Setup Flat File Connection with CSV file, as mentioned Basic Example of Data Flow Task.
2. Right click on Flat File Source, and click on Show Advanced Editor:
 

3. Click on "Component Properties" and go to FileNameColumnName, Custom properties:

 

4. Setup FileNameColumnName value with desired column name. Let's say "File Name". Congratulations, This column is added to output list with actual filename of that connection.

 

Let me know your comments/questions.

Tags

Tejas Shah SQL Tips Data Flow Task SQL Developer SSIS For Each Loop Container SQL Server 2005 SSIS Task

About me

User

Tejas Shah

Microsoft Certified Professional Expert. I have 14+ years of experience in Design and Develop 100+ .Net applications using Asp.Net, C#, Asp.Net Core, VB.Net, SQL Server, MVC, AngularJS, JavaScript, Azure, HTML5 and CSS3.

Read More

Categories

Recent Post