Technology Musings
Use this technique to reduce repeated trips to tables to lookup record details. Instead, cache the information once and reap speed benefits throughout your code
In: SQL Server
19 Apr 2010Given a table with one column as an identity, how you default another column to the identity of the first, while retaining the ability to change later
Neither SQL Server 2008 nor Office 2007 install Microsoft.ACE.OLEDB.12.0 providers. With a small tweak, we can enable connections to Excel and Access 2007.
In: Microsoft
16 Nov 2009The new Office 2010 Beta just dropped on MSDN and TechNet. The package is available in both 64-bit and 32-bit flavors; download details for both appear below.
In: SSIS
14 Oct 2009If you need to access a custom .NET Assembly from an SSIS Script Task, Microsoft doesn’t make things very easy – but it’s still possible with a little setup.