blogs.conchango.com

March 2006 - Posts

• Creating Ad-Hoc Reporting with Reporting Services and Report Viewer with-in .net programs

  We had a requirement which was to give a (WinForm) system, which uses a SQL Server 2005 Express database, simple table structure ad-hoc reporting. Another requirement was to allow all the reports to be exportable to other formats i.e.: HTML, CSV, Excel Read More... Posted 31 March 2006 14:54 by steve.wright | 2 Comments Filed under: Reporting Services 2005, .Net 2.0, Reporting Services

• Installing SQL Server 2005 Express with Remote Connections.

  I have managed to set-up a SQL Server 2005 Express instance, on a windows-XP machine, with remote connections enable. The actual installation of the SQL Server 2005 express instance was straightforward, but enabling the remote connections was problematic. Read More... Posted 23 March 2006 09:18 by steve.wright | 0 Comments Filed under: SQL Server 2005

• SSIS Creating Synchronous Transform Component

  Do you need to write a custom component to transform input data, and disregard this input data, instead, replacing it? That's was what I needed to accomplish with my component. It takes data from the input buffer and performs a lookup via an external Read More... Posted 14 March 2006 14:28 by steve.wright | 0 Comments Filed under: .Net 2.0, SQL Server Integration Services, SSIS

• SSIS File handle leak in For Each Loop

  I am currently working on a project which needs to load over a 1000 xml files. The files are stored across 10 subfolders. I am using a foreach loop with a file enumerator, which is configured at the top of the folder structure and traverses the subfolders. Read More... Posted 02 March 2006 16:57 by steve.wright | 0 Comments Filed under: SQL Server Integration Services, SSIS