Are you using the union operator in SSIS or in the sourcequery itself?

Sure that you retrieve all rows in sqldeveloper?

Looking forward to sqlserverdays at the end of september.

Barn, report builder 3 (web-SSRS) doesn't allow selfjoins or joining a table twice because it can't alias tables properly (common dimensions?)

Kindly vote...

Do you have the oracle client installed on the server (especially the oledb driver) and rebooted?

Synonyms work in Oracle, anxious to test them out in MS SQL Server.

I miss the advanced query designer of Access in SharePoint reportbuilder, where you can actually modify sql text and verify it graphically; instead of "oops, you modified the sql-statement, no...

There is an upgrade path from 2008 to 2012.

Not sure if the converted ssis-packages will run out of the box.

Found this link about upgrading ssis to 2012

Thanks for the response.

I was hoping on some magic as the graphical query designer in Report Builder 3 doesn't alias tables nor accepts modifications in the sql.

Funny! :w00t:

Anyway the Belgium Red Devils got past the USA soccer team after a thrilling match.

Can you elaborate further?

if you had the 3 tables grade,owner,ownergrades

it would be something like

select owner

from owners

where (

exists (select * from ownergrades inner join grades on ownergrades.grade=grades.grade and ownergrades.owner=owners.owner and...

What is exactly the problem? The acquire connection or the unicode conversion?

Have you tested the oracle connection from the server using "sqlplus" for both the clients?

Just to improve my english, what is the meaning of "Rodders..."?

Members of a hotrod club

or maintenance (access?)

or the thing you use to unclog pipes (duct rodders)

Can you give an example of "only display the numbers after the decimal related to random"?

Have a look at Salted Password Hashing - Doing it Right

Rnd is a random function

Hello,

The code looks like php

You'll have to construct a query with the where exist clause Koen mentioned.

Did some googlefu and ended up with:

insert statements with codeigniter

query with codeigniter