Hello Everyone,
I€™m doing a type 2 SCD, Flat File as my source and oracle table as my destination but there is a problem in SCD component. I'm getting error.
is SSIS accessible to oracle as destination if yes please do inform me how do i resolve this issue.
Thank you
I have to connect a SQL Server to oracle 8 using a linked server. I was given an id and password from the Oracle side to do this, and using the Oracle OLEDB driver from SQL can link the server, but get an msodra error when I click on the tables icon in EM. THis is set up on another SQL Server but the person who did this left. Is there anything else on the SQL Server which needs to be loaded?
View 1 Replies View RelatedHi,
i am facing a scenario is that, iam matching table one table form oracle and another table form sql
what is want is that using this two tables i want to display unmatched record from the orcale table
very urgent help me please send the code for this scenario
example
in sql table i have
fldinvoiceno
00000001
00000002
in oracle table i have
fldinvoiceno
00000001
00000002
00000003
so matching the two table i need to get 00000003
I need help in creating a custom string for a multi-value parameter going against an Oralce 8 database.
I'm trying to build a string that looks like ('1401', 'HACT', '1504')
If I do it as an expression in a test report the results are perfect but in production it does not like it.
This is what I have based on some examples I have found but it complains it needs a )
These are the last few lines of the query
and f.shipto = a.shipto
and f.salesman in & " ('" & Join(Parameters!Salesrep.Value,"','") & "')"
GROUP BY a.company_id, a.whse#, f.salesman, .product_line, d.product_group, e.name
)
order by conoxx, whsexx, slsrepxx, sortcode
Hi,
why Table or View €“ fast load option in Data Access mode is not listed when we connect Oracle Database in the OLEDB Destination.
Thanks
Jegan