Idea: Import-DbaCsv - option to include filename in new field #8511
              
                Unanswered
              
          
                  
                    
                      match-gabeflores
                    
                  
                
                  asked this question in
                Ideas
              
            Replies: 0 comments
  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment
  
        
    
Uh oh!
There was an error while loading. Please reload this page.
-
I often have to load a group of csv files (sometimes 20+) into one single table. Example loading monthly CSV files into one destination table. Import-DbaCsv works great for this. Not sure if this is possible, but it would be convenient if it could also include an additional field with the filename (either filename or the full path) in the table. This would be a separate optional parameter.
example: if loading two files (with just field
field1), example table schema would look like this.Beta Was this translation helpful? Give feedback.
All reactions