Monday, July 23, 2007

FFClickOnce :: Firefox Add-ons

Just wondering why the ClickOnce deployment fail in Firefox.

M$ was saying that ClickOnce only run on IE in MSDN.

Here is a nice plug-in for Running ClickOnce app in Firefox:
FFClickOnce :: Firefox Add-ons

Friday, April 20, 2007

VS IDE bug?


It seems the VS2005 IDE is still not quite stable...and not quite responsive too.

Saturday, April 14, 2007

Row Number Transformation

Here is a Row Number Transformation component of SSIS
http://www.sqlis.com/93.aspx

It's great, just fit my needs.
I suppose SSIS should provide this component...

Saturday, April 07, 2007

Performance of SSIS Package

I think I need to study Database Tuning later... when I have time.

Recently I'm doing a Data Conversion project.
There are around 1.x million history records storing in 70+ VFP tables (1 table for each month).
I've made a looping package (it's new, great job M$!) to import such tables.
But the performance of the package is just bullshit.

Well, I guess the bottleneck is on VFP side (maybe VFP OleDB Provider, or File I/O of such VFP files (.dbf, .fpt ...).

Monday, February 12, 2007

SSIS IDE bug...?

Recently I am studying SSIS for my project.
I was stuck at some points while importing data from a VFP table.

The Execute Package Utility kept saying that there is a Truncation Error.
After spending for the whole afternoon, I got it...

It is because the IDE (VS2005) didn't always refresh the length of my source columns.

SSIS Home: SQL Server Integration Service
http://msdn2.microsoft.com/en-us/library/ms141026.aspx

well, I will patch my VS2005 up to SP1...soon