Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

On the Fringe

Chim Kalunta is a Database Systems Developer and Independent Consultant working out of the UK. An MCITP: Database Developer and an MCITP: Database Administrator, he can be reached at chimkalunta.com.

Index Scripting with Powershell

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

0 comments, 369 reads

Posted in On the Fringe on 21 March 2014

Doing it with the EzAPI

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

0 comments, 472 reads

Posted in On the Fringe on 9 March 2014

Creating and Executing an SSIS Package Programmatically

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

0 comments, 3,809 reads

Posted in On the Fringe on 25 August 2013