grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘ODBC’

ETL Method – Fastest Way To Get Data from DB2 to Microsoft SQL Server

May.20, 2009 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

For a while, I have been working on figuring out a “better” way to get data from DB2 to Microsoft SQL Server. There are many different options and approaches and environments, and this one is mine, your mileage may vary. Usually, when pulling data from DB2 to any Windows box, the first thing you might [...]

View Comments | 4,598 views

SSIS – Two Ways Using Expressions Can Make Your Life Easier – Multi DB Select, Non Standard DB Select

Apr.30, 2009 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

In SQL Server Integration Services (SSIS), pretty much every task or transformation lets you set “expressions” up. Expressions are basically ways to set property values programmatically. Here are two scenarios where you might use expressions (there are 100’s of uses, these are just two that are kind of related). Multiple Database Select – You have [...]

View Comments | 3,797 views

  

Business Intelligence, SQL, Geek, Music, Programming, and More!

Welcome to stevienova.com. This is my personal blog. I like to write about mostly geeky stuff (Programming, .NET, Microsoft, C#, SQL, Business Intelligence, iPhone, Apple, Mac, Networking, etc) and other stuff that I just run across and feel like posting up to the net!