Awesome guide for installing/configuring SSIS
A good friend of mine, Matt Ross, a super-DBA, developer, expert on Windows/VMWare/AD/etc., and teaching associate at North Lake College in Irving, TX, wrote a sweet guide for installing and configuring SSIS [1], and I talked him into letting me post on my blog. Some of the material you are probably familiar with if you have installed SQL Server and SSIS, but some of it might be new to you, especially the sections on SSIS and Oracle and DB2 connectivity. There are quite a few gotchas (especially with Oracle and 32/64 bit), and this guide might give you some tips and pointers, and save you quite a bit of time and headache when you’re doing your next install. I know Matt wished he had his doc when he was going through the exercise.
Check out the link, below, and give me your feedback. I believe that it just might help someone out down the road somewhere.
Get the file here SSIS Build Sheet
Lee
-------------------------
Don’t be this guy when you’re trying to connect to Oracle from SQL Server
References:
[1] Park, J. (2009). Accessing Oracle From 64bit SQL Server or SSIS. Retrieved on 2/18/2010 from http://knol.google.com/k/accessing-oracle-from-64bit-sql-server-or-ssis#
-------------------------------------------------------------------------------------------------------------------------
Enjoy the post? Come to my blog for research and learning, with a bit of humor thrown in as well.
Join my group on facebook – Let’s chat, discuss various topics, and share experiences on Microsoft SQL Server.
5a0034e6-65f0-4b03-9156-968e234cacf5|0|.0