Benjamin Wright-Jones

Exploring Information, Infrastructure and Solution Architecture

Browse by Tags

Tagged Content List
  • Blog Post: Using SSIS with SQL Azure databases

    I’m quite surprised how easy it is to setup an SSIS package to read and write data to a SQL Azure database.  A simple data flow task with an ADO.NET Destination is easy to setup, just make sure the SQL Azure table has a clustered index otherwise writing data will not work (as this is a pre-requisite...
  • Blog Post: Using an SSIS package to monitor and archive the default trace file

    I find it frustrating that the SQL Server 2005/2008 default trace is continually overwritten and there is no way to store x number of files or x MBs of data.  As a workaround, I developed an SSIS package to monitor the \LOG folder and automatically archive the default trace file whenever a new file...
Page 1 of 1 (2 items)