blogs.conchango.com

Browse by Tags

• Foreach Loop
• SQL Server
• SQL Server Integration Services

• SSIS: Keep a scratch project

  Here's a little tip for you that I've found incredibly useful over the past few months - something that I suspect a lot of you do already. When I'm involved in a project on which I am implementing SSIS packages I like to keep all packages Read More... Posted 03 July 2007 05:11 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, Inane Waffle, SSIS

• SSIS Nuggets (and the perils of commuting)

  I hate commuting. There's no two ways of saying it, I despise it. Every day I face the 70 minute grind of trekking into London on a packed commuter cattle-wagon and the same back again. And I'm one of the lucky ones, I get on the train when there are Read More... Posted 04 July 2005 09:16 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, Inane Waffle, SSIS

• Understanding Microsoft Integration Technologies

  My colleague Matt has directed me to a quality paper explaining the difference between all of Microsoft's integration technologies and where each is appropriate. It covers Indigo , MSMQ , SQL Server Broker , SQL Server Replication , SQL Server Integration Read More... Posted 14 June 2005 16:52 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, Inane Waffle, SQL Server, SSIS

• SSIS: Enumerating files in a Foreach loop

  I've just got back from a Charlatans gig at Hammersmith Palais in London. Anyone that knows me will tell you that I'm a massive massive Charlatans fan so I've had a great night. They played alot of stuff from earlier albums like "With No Shoes" from Tellin' Read More... Posted 30 May 2005 00:59 by jamie.thomson | 44 Comments Filed under: SQL Server Integration Services, Inane Waffle, SSIS, Foreach Loop

• E3 : ETL, EAI & EII

  Previously I have talked about ETL and EII , Analysis Services's support for EII & SQL Server Integration Services's (SSIS's) support for EII without explaining too much about what EII actually is - largely because I didn't know. Well, I have now Read More... Posted 27 April 2005 09:42 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, Inane Waffle, SQL Server, SSIS

• ETL and Data Integration

  There is an interesting article today on The Reg authored by a researcher from Bloor Research who gives his views on IBM's lack of visiblity in the ETL arena. Whilst IBM's efforts (or lack thereof) in this area are unlikely to affect me as a Microsoft Read More... Posted 11 March 2005 09:26 by jamie.thomson | 7 Comments Filed under: SQL Server Integration Services, Inane Waffle, SSIS