Need Article/Information - 2 databases 1 report

Hi All,

I need to find information on how to get two oracle databases data into one report. The two databases are not really a like, althought they do "talk" to each other and pass data to each other, and their tables are not the same. One is a manufacturing database, the other financial. If anyone can point me in the right direction, that would be great.

I am working with the newer 2005 products.

Thanks in advanced,

Kerrie

Kerrie,

i can't tell you how to collect data from Oracle, but i can tell you how to combine two streams of data. You need to create two reports - one being the main report, the other being a simple one, the simple one then serves as a sub report inside the main report. For instance, if you are showing the data in a table in the main report, then you can embed the subreport in a table cell, and pass values into it as parameters.

Or you can use the existing database link between the two databases (you said they are talking already), and just return all the data in one query. This will make the query slower, but the report will be way easier.

|||

Sluggy,

Thanks for the reply, Thats what I will do!

Thanks again,

Kerrie

Need a list of Error Code

Hi,

When we configure a transformation to redirect the error record, SSIS gives 2 columns: 'error code' and 'error column'. In one article, I have seen how to get the error description using the 'error code'.

My questions are,

Where I can get list of all possible error codes? 'error column' gives the id of the column. How to get the name of the 'error column'?

Thanks.

Basically you need to know the metadata of the normal output, not that easy, but simon has wrapped this up in a Tx.

http://sqljunkies.com/WebLog/simons/archive/2005/12/15/SSIS_Enhanced_Error_Component.aspx

Some related info -

http://msdn2.microsoft.com/en-us/library/ms345163.aspx

The SSIS error codes are listed in BOL. I also have them on my wiki, because BOL only got them in an update and I wanted them before that, and also you can add notes on the errors on the wiki.