I’ve been actively seeking out opportunities to do more stuff with Powershell of late.
I had wanted to script out only the Indexes on Tables in a Database and remembered SQL Server Management Studio doesn’t make this as easy as it could be.
I can’t say that I’ve done my… Read more
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that comes with SSIS to build a Package that sourced data from a flat file and loaded it into a Table in a SQL Server Database.
I also mentioned another… Read more
One of the nice things about SQL Server Integration Services (SSIS) is its extensibility.
If you find you have need for a Data Flow Source, Transformation or Destination that doesn’t come stock with SSIS you can roll one of your own. The same goes if you wanted to manage the… Read more