1.how to fastload data to an Oracle destination.
2.what if i need to add an identity column to the destination table.
Is a sequence needed? how can ssis2008 handle that?
thanks in advance.
View Complete Post
could any one tell me how could i load data from EXCEl file to XML
if some one could provide with appropriate link then it will b a great help
i have taken Excel source part is completed ..but what to do after that..
Transferring 2 million records from SQL server to Oracle using simple OLE DB Source and Destination in SSIS.
The package hangs in yellow showing 7000 rows passed to destiantion, nothin happens for hours, next day I came in and saw 70000 records processed and still in yellow.
Today the same thing is happening. It works(2 million records processed in 40 secs) when I change the destination to SQL Server. I am guessing its something to do with the Oracle destination. I am really new to oracle environment.
So what can I do? is it something I have change in SSIS pakcage or the destination itself. If you guys need more info about this. please ask. Thanks
I have used the above method to configure my crystal report ...
Its working fine , But i have huge number of data in database ....
So , it take long time to load the report ...
So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.
Plz help me with this issue ...
Also , Plz explain me abt index legend in crystal report.
I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where
i can just call the method with my SQL Query
Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");
Plz Post the link if there is any open source !
A data source control is a server control that wraps some basic functions of a data source - be it a SQL Server database, an XML document, an Excel worksheet, or a sitemap description. Through the services of a similar component, data-bound controls can fetch data as well as insert new records or update and delete existing ones. Data source controls enable a consistent model across a variety of data sources and dramatically reduce the amount of code needed to implement a two-way data-binding scenario. This article provides an introduction to data source controls and other related data binding features.
MSDN Magazine June 2004
Here is my SP:
create or replacePROCEDURE ZGETUSERSSIGNONS (vUid IN VARCHAR2, p_getuserssignon_recordset1 OUT SYS_REFCURSOR) ASBEGIN Open p_getuserssignon_recordset1 for SELECT Distinct(Userid), UserPassword, SecurityLevel, ActiveStatusFROM ZSIGNON WHERE substr(UserId,1,2) <> vUidOrder By UserId;END ZGETUSERSSIGNONS;
I would like to run this SP from code and fill a gridview with the result.
I am not sure how to go about this, as I have found several different examples, other than the one I think I need.
I am using the oracle data provider and I have an input parameter (vUid, which will equal "zz").
First question. When filling a gridview with a result set from a stored procedure should the recordset OUT be defined as a REFCURSOR (like i did above)?
Do you have example code as to how to execute the SP and fill a gridview? I keep trying different variations of code i've found on the internet without any success other than getting more confused.
(I am using VS 2005, VB).
I have succeffuly Imported the ADF and have also successfully created a Business Data Column. But when I try to query data , I get the following error
An error occurred while retrieving data from Oracle Instance. Administrator, see the server log for more information
And this is what I found in the Application Logs
A Metadata Exception was constructed in App Domain '/LM/W3SVC/81256521/ROOT-1-129217212004078822'. The full exception text is: LobSystem could not be found using criteria 'id=476'.
I have a Ajax Accordion control on my page with treeview in Content Template. As the treeview for each pane are big. I am wondering whether I can load the treeview from codebehind only after the pane is selected. I can reuse the code from ItemDataBound of Accordion control.