Oracle OLE DB source in SSIS

›
An OLE DB source to Oracle can be added to a SSIS package. Example data Server : locksnlatches.mydomain.com Oracle instance/SID : dwh ...

Reference SQL Server table with spaces from Oracle

›
It is possible to select data from a SQL Server table that contains spaces by using a database link from Oracle. The syntax is as follows:...

Query Oracle from SQL Server

›
Start with the following steps: Install the Oracle Instant Client (OIC) on the machine where SQL Server is running and add the ...

Power view on analysis services tabular

›
How to create a Power View report using Sharepoint 2010 and Analysis Services 2012 Tabular as the data source? 0) Prerequisites A server ...

Annoying search engine abroad question

›
Google Chrome asks you if you would like to use another omnibox search engine when you move from one country to another. When you move acros...

Quipu connections

›
Several ways to create a database connection in the open source data warehouse generator Quipu . SQL Express SQL Server configuration mana...
1 comment:

Live calendar displays incorrectly in Chrome

›
At last the Windows Live calendar displays appointments correctly again in the latest Google Chrome beta release, 14.0.835.2. They fixed the...

Working with dates in OBIEE

›
Here are several options to set date formats in OBIEE. Option #1 is the best way to work with dates and comparison of dates to strings conta...
2 comments:

No login prompt for Exchange

›
It is possible to suppress the login prompt that appears in Outlook, when trying to connect to an Exchange server via Outlook Web Access. ...

SkyDrive photos in Flipboard

›
Flipboard is a great app for the iPad. It displays a collections of RSS feeds as a magazine. The latest version (1.1.1) offers the ability t...

Combine two DVD's into one

›
When you want to combine two DVD's onto one disc, but keep the chapters, then try the following steps. I assume the video_ts folders of...

Use 32-bits Excel Source with 64-bits SSIS

›
The following is still work in progress and more of a braindump than anything else, but I've put it here, because someone might already ...

Increase maximum volume of the iPad

›
If you find that the maximum volume on the iPad is not loud enough, then you can fix that with the following adjustment: Start Cydia If yo...
3 comments:

Internet on iPad via adhoc wifi hotspot

›
Scroll down for the solution, read on for some trial-and-error background info. When no direct wifi internet connection is available, then...

Bluetooth device not found on Dell laptop

›
If you are sure you have a built-in bluetooth device on your Dell laptop, but you cannot find it in control panel or device manager, then tr...
1 comment:

CTAS disregards number precision and scale

›
When using a "create table as select" (CTAS) to create a table based on a query, when that query also contains a window function/a...

Subtitle Workshop blank screen with Matroska/MKV containing H.264

›
Scroll down to solution for the workaround to get video in stead of a black screen. Read on for a little bit more background information. ...
11 comments:

TNS service names ODBC dropdown box garbled, messed up, gibberish

›
Most likely cause is that there are two or more different Oracle clients installed, with two or more home folders and tnsnames.ora files. ...
1 comment:

CDBurnerXP: drive not recognized

›
CDBurnerXP is a freeware tool for burning CD's and DVD's, including blueray. However, it sometimes does not recognize the drive to b...

The nearby-future of storage

›
The ioDrive Duo by FusionIO out-performs even multiple SSD's placed in parallel. The 320GB version of the ioDrive has a read/write speed...