Technology Musings
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.
Using the MySQL ADO.NET provider, SQL Server Integration Services can natively query MySQL databases, providing an easy method to transfer data between systems.
In: SQL Server| SSIS
3 Feb 2009Just a quick note advising that I’ve updated my Handling Embedded Text Qualifiers post to also include a Visual Basic example, making the information also relevant to SQL Server 2005.
In: SQL Server| SSIS
26 Jan 2009Import the XML dump of Wikipedia data into SQL Server through SSIS. Full walkthrough with pictures and pre-configured SSIS package provided.
In: SQL Server| SSIS
24 Nov 2008SSIS does not allow an FTP password to be set through Expressions. Fortunately, we can manually set the value stored in a variable through a Script Component.