Kasper de Jonge BI Blog

Thanks to the great discussion some of us had on Twitter and the follow up on the PowerPivotPro blog we now know a PowerPivot API will be available in the future:

Patience guys. The API will be there.

We are just crunched on time to ship V1.0 of PowerPivot (remember – just 18 months from SQL 2008). But we have the full intention of exposing the API in full.

As MS BI consultant i’m really looking forward to PowerPivot but as developer with C# affinity i’m really excited on the prospect of the PowerPivot API. Think of all the potential projects you could do!

I needed to test my SSIS import package which reads files every minute, to test this i want a program that moves files from one directory to the SSIS import directory, the filename has to be sorted on filename (it consists of datetime) so i get a more real import.

I first tried to create a SSIS to package that can do what i want but after some searching that i decided to create a simple C# file.  I found this great post to help me sorting my filenames using IComparer:
http://webdevel.blogspot.com/2007/09/sorting-files-by-name-date-filesize-etc.html