SSIS

Links of the Week (9/25/2009)

by Jonathan September 25, 2009

SQL SQL WHERE Clause Optimization – Query optimization can make or break an application.  Understanding how a WHERE clause can affect a query is very important.  This article helps shed light on that. Creating Dynamic Output in SSIS – SQL Integration Services is one of SQL Servers most powerful features.  This article will demonstrate how [...]

View Comments Read More…

SQL Server Integration Services

by Jonathan June 3, 2009

I was recently asked to work on a project where I needed to export data from our accounting database, transform it and then insert it into another database to be accessed by application in our edge network. Having spent most of my days as a ‘Jack of All Trades’, I had yet to dig into [...]

View Comments Read More…

Technology Links of the Week (06/2/09)

by Jonathan May 21, 2009

OS X 15 Terminal commands to supercharge OS X – Great tips for OS X users comfortable running commands from the terminal SQL Connectivity Options for Microsoft SQL Server 2008 Integration Services – SSIS can change the way you look at SQL Server. This article shows many of the ways that you can connect to [...]

View Comments Read More…

Technology Links of the Week

by Jonathan May 2, 2009

SQL How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video) – Microsoft video demonstrating how to set up an SSIS package in SQL Server Management Studio SSIS Get all from Table A that isn’t in Table B – Tutorial for SSIS scripting and data manipulation. A good introduction to [...]

View Comments Read More…