SSIS

Links of the Week (9/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 [...]

1 comment More…

SQL Server Integration Services

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 [...]

0 comments More…

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

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 [...]

1 comment More…

Technology Links of the Week

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 [...]

0 comments More…