blogs.conchango.com

I have spent the last couple of days helping a client over the initial hurdles of SSIS familiarisation. I enjoy doing gigs like this because it highlights to me what difficulties people have when they first encounter SSIS and is a good reminder of the difficulties that I faced when I first encountered the product back in the heady days of summer ...

Scene Setting Its a common scenario when doing data integration that one has to process datasets containing redundant data. In many cases this is when data is received in flat files and all data is put into a single file for ease of transport. Perhaps this is better explained by way of illustration; below is a fragment of a file containing order ...

SQL Server Integration Services (SSIS) 2008 is bringing with it new capabilities. One of the biggest new features is the new scripting engine. Previously Visual Studio Tools for Applications (VSA) was used as the scripting engine but that has now been superceded by Visual Studio Tools for Applications (VSTA). In the video below I ...

Checkpoint files are very useful mechanisms for recovering failed packages and I have talked about them quite a bit before, however, they do have one or two limitations. One thing that people typically want to do is always execute a particular task regardless of whether a checkpoint file exists or not. There may be a number of reasons for this - ...