Author name: Russ

In a previous post, I demonstrate how to reshape a comma delimited file (CSV) using PowerShell. I noted that the results put all of the column values in double quotes: “ID”,”Name”,”State” “5”,”Stephanie”,”Arizona” “4”,”Melanie”,”Oregon” “2”,”Katie”,”Texas” I used this code to produce this result: cd c:\MyFolder Import-Csv -Path SampleData.csv|Where {$_.Country -eq “USA”} ` | SELECT ID, Name,

Here is a use case for what I am thinking of. You have comma delimited file that you need to load into SQL Server. It is a very large file that you need to join to an equally large table in a database. For example at one place I worked we had a set of

PowerShell has power to handle many ETL tasks (PowerShell as an ETL tool). In this post I illustrate how you can use PowerShell to shape a comma delimited file. That is, how to remove columns, filter rows and sort the file output. Let’s start with a simple file (SampleData.csv): ID,Name,State,Country 1,Russ,Sandys,Bermuda 2,Katie,Texas,USA 3,Gail,Sandys,Bermuda 4,Melanie,Oregon,USA 5,Stephanie,Arizona,USA

“If Your Only Tool Is a Hammer Then Every Problem Looks Like a Nail.” My hammer has been SSIS for most of the last 8 years. I have reluctantly used scripting language like .Net framework (C# and VB.Net) and even VBA and (don’t choke) Visual Basic 6.0. But I think that I have found a