Batch Insert (OLAP)

Feb 7, 2005

Hi can any one help me with the skeleton script (sample one)of running Bulk insert in batches........ I need to do it in batches as the input data is huge.....

The logic is I have to insert thru bcp in fact table...

After that batch execution for 50,000 thousand record.... wise.... if any of the batch failes i need to identify and have to rerun from that point onwards...... this is OLAP thing...

View 6 Replies


ADVERTISEMENT

Batch Insert

Jan 23, 2004

I'm using ASP.net to do a Select and I want to insert all the results into a table that is stored locally
I can put an SP local but cant put on the other DB

How would i achieve this batch insert? is it possible?

thanks
Mark

View 4 Replies View Related

How To Speed Up Batch Insert MSSQL

Mar 20, 2008

Hi,
I am in the middle of writing a console application that acquires data from dynamic odbc connections and inserts the results into a MSSQL database. I'm currently using a datareader to generate multiple calls to a stored procedure and batch execute them by means of a simple counter; this works fine.
However, I'm a little concerned that it seems to take so long to execute the sql stored procs and was wondering if anyone may know of any methods to help speed it up either on the app side or sql, or both.
I had a quick word with our dba who spoke briefly about some kind of process where by the application fires the request across to the database and carries on leaving the db to queue the request or something to that effect. He ran away before I could get any sort of sense out of him.
 Any help greatly appreciated
 Thanks

View 4 Replies View Related

Bulk Insert And Batch Size

Mar 31, 2015

How do you prevent this:"If you import a very large number of rows, dividing the data into batches can offer advantages. After each batch complete, the transaction is logged. If, for any reason, a bulk-import operation terminates before completion, only the current transaction (batch) is rolled back." How can I let the whole batch rollback, instead only the current transaction (batch) rolling back?

View 1 Replies View Related

JDBC Batch Insert + GetGeneratedKeys

Apr 13, 2007

I'm using MS JDBC driver to connect to SQLServer 2005 and trying to perform batch insert. Here is the code i'm using:




Code Snippet

try {
// Assume we have a valid con
con.setAutoCommit(false);

// this is the simplified SQL for the purposes of this example
StringBuffer sql = new StringBuffer();
sql.append("INSERT INTO temp_batchOpt (");
sql.append("temp)");
sql.append(" VALUES (?)");

PreparedStatement insertStatement =
con.prepareStatement(sql.toString(),
SQLServerStatement.RETURN_GENERATED_KEYS);

for (int i = 0; i < 10; i++) {

insertStatement.setInt(1,3);
insertStatement.addBatch();
}

int[] r = insertStatement.executeBatch();

// the correct number of insertions are made
if(r != null)
for(int x: r)
System.out.println("inserted "+x);

SQLServerResultSet keyRS = (SQLServerResultSet)insertStatement.getGeneratedKeys();
while (keyRS.next()) {
int id = keyRS.getInt(1);
System.out.println("**filling id ="+id);
}
con.commit();
} catch (BatchUpdateException bue) {
bue.printStackTrace();
}
catch(SQLException sqle){
sqle.printStackTrace();
}
finally {
// close the connection...
}



I'm getting the following exception:




Code Snippetinserted 1
inserted 1
inserted -2
inserted 1
inserted -2
inserted 1
inserted -2
inserted 1
inserted -2
inserted 1
com.microsoft.sqlserver.jdbc.SQLServerException: The statement must be run before the generated keys are available.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getGeneratedKeys(Unknown Source)
at com.x.U.m.Transformer.prefetchData(Transformer.java:285)
at com.x.U.m.Transformer.init(Transformer.java:51)
at com.x.U.m.XMLParse.main(XMLParse.java:215)



I can get the getGeneratedKeys() to work fine with single update (not usign batch update). Is batch + getGenerated key not supported?

TIA

View 4 Replies View Related

DB Engine :: Batch Insert During Full Backup

Sep 9, 2015

I have a full backup scheduled at 12.00AM ET and have a batch import on 11.55PM(5 min before full backup) which takes 30min to complete .Will the backup cover the data which is being imported?

View 2 Replies View Related

Batch Insert 10000 Rows At A Time And Commit

Jul 20, 2005

I want to Insert 10000 rows at a time and commit in sql server , Isthere a way to do it if the source tables have no id fields ?What would be the most efficient method?ThanksAjay

View 1 Replies View Related

ODBC Batch Insert Error On Windows 64 Bit Machine.

Jan 16, 2008

I€™m facing a SQL batch insert issue on Windows 64 bit (IA-64) platform. I€™m using €˜Column-Wise Binding€™ of parameters. The example program hosted on Microsoft site (http://msdn2.microsoft.com/en-us/library/ms709287.aspx) returns error of SQL_NEED_DATA for batch insert on Windows 64 bit platform. The same code works fine on 32 bit platform. I€™m using SQL Server 2000 as the database and tried using both native SQL server ODBC driver and Merant 5.2 ODBC drivers. Any help on this will be greatly appreciated.

View 5 Replies View Related

OLAP Services: Automating Archival/Restore Of OLAP Databases

Sep 19, 2000

Hello All,

Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.

--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220

Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com

"Once in a while you can get shown the light
in the strangest of places if you look at it right"

JG 1942-1995 RIP

View 1 Replies View Related

How To Repair A Corrupted OLAP Database? (was Olap!:)

Jun 12, 2007

How to repair a corrupted OLAP database?

View 2 Replies View Related

Passing Parameters To Batch File And Executing Batch File Loop

Aug 7, 2007

HELP,

I need to take a variable from a tabel in SQL Server pass to a Batch file and execute the batch file. Right now I can exec the batch file with XP_CMDSHELL but how can I pass the variable to the batch file and loop through all the variables.

Please help

Phil

View 4 Replies View Related

SQLCMD Batch File With Script In Batch File

Dec 5, 2006

I am using the following batch file to execute a script that creates a db and all its objects in the local sql express:

sqlcmd -S (local)SQLExpress -i C:CreateDB.sql

This works fine, but I'm wondering if there's an easy way to put the script in the batch file, so users don't have to worry about putting the script in the C drive. I tried getting rid of the i parameter and pasting the script from the sql file into the batch file, but it didn't work.

Thanks,

Dave

View 1 Replies View Related

OLAP And ASP.NEt

Aug 2, 2005

Hi,


I am looking at deploying an ASP.NET site which accesses an OLAP database - Microsoft Analysis Services


My question is how is this normally done:



Straight SQL / Stored Procedures

3rd party Adhoc plugin

Anything else



If there is anyone out there with experience in using ASP.NET and
Analysis Services I would be interested in hearing how they did it -


Database Architecture
System Architecture



and any
pitfalls etc...


Thanks in Advance

Jerry

View 2 Replies View Related

OLAP

Aug 12, 2005

Does any one know a very good control for OLAP in ASP.NET?

View 2 Replies View Related

OLAp And MDX

Jul 28, 2000

How do I use vba string functions in MDX queries? The on-line help says that the functions can be used but I can't figure out the right syntax for it. PLEASE HELP!
I want to take the first letter from a level i.e.([NET INCOME] in the e.g. below) and display it.

For eg.
WITH MEMBER [DIMENSION].[NET INCOME].A AS 'LEFT({[DIMENSION].[NET INCOME].MEMBERS,1})'
SELECT
measures ON COLUMNS,
[DIMENSION].MEMBERS ON ROWS
FROM CUBE a.

View 2 Replies View Related

OLAP

Jan 17, 2001

I have install OLAP srvice on SQL Server 7.0 server.
When I try to connect to OLAP server I get the following error:
'cannot connect to the registry on the server computer'

Does anyone know how to fix this problem.

Thank You,
Mark

View 2 Replies View Related

SQL 70 And OLAP 2K On Same Box

Sep 25, 2001

Has anyone tried installing an OLAP Manager 2000 instance on a server that already supports SQL 7.0 and OLAP 7.0? We will not be using the OLAP 7.0 instance so we would like to either upgrage OLAP 7.0 to OLAP 2000 or unistall OLAP 7.0 altogether. Any feedback would be helpful. Thanks. James.

View 2 Replies View Related

Olap

Jul 7, 2004

hi,
i need "microsoft(r) sql server(tm) 2000 analysis services step by step" in digital,can you help me ?
shawnlee@cena.com.cn

View 1 Replies View Related

OLAP Help

Jan 20, 2004

i do not know if i am posting in the right place so forgive me if i have.
also i have search and cannot find any answers to this.

ok, i have Windows server 2003 and i want to run SQL on it, i got SP3a and i found out i need something like OLAP, and my PC does not have OLAP on it.

so i was wondering if someone will tell me how/where i can get if from.

thanks alot.

Mrbob2

View 5 Replies View Related

OLAP

Mar 20, 2007

Mary writes "Hi
Could you give me some notes about ALAP ? What is ALAP exactly? What is the usage of this part of SQL? Could you give me some example.

Thanx"

View 1 Replies View Related

I Can&#39;t See OLAP Databases ?

Jul 6, 2001

I was working with an OLAP Services Processing Task when I ran
into some difficulties. I was prompted with a message which told
me that the object could not be found.
When I went back to the OLAP Manager I was not able to see the
databases for that server.

Does anyone know why I can no longer see these databases i have
tried refreshing/rebooting......??

Thanks,
Ruaidhri.

View 1 Replies View Related

OLAP Security

Oct 2, 2000

Analysis services is installed on a Windows 2000 server (call it computer A) in Domain A. SQL 2000 has been installed on the server using mixed security. All of the SQL services are running under an account in Domain A (not local system).
The problem is the computer (call it computer B) I wish to run Analysis Manager on and use to administer the Analysis services on Computer A is in Domain B. There are no trusts between Domain A and Domain B.
Can Analysis services be administered by a computer in a domain not trusting the domain that the server running Analysis server is in?
Any help would be appreciated.
Thanks

View 2 Replies View Related

OLAP - Very Urgent

Dec 6, 1999

Hi,
Can anyone tell me where to fine some good help on designing Date type dimensions in an OLAP cube.
This particular thing has been a pain for me..
I have a Time dimension in my CUBE which has year-week-day as levels.
I want the week to start from Monday and span seven days ( naturally !! ). But OLAP surprises and entertains me by showing different number of days in every week. Whatever I do, it never starts a week on Monday and spans it for next 7 days consistently.

Help.

View 1 Replies View Related

OLAP Manager

Mar 29, 1999

I've installed SQL7.0 and OLAP service on my PC(windows 95), but I cannot find the OLAP Manager. Can an OLAP Manager be installed on Windows 95? If it cannot, can I create an OLAP database (or application) on my PC?

View 1 Replies View Related

OLAP Server

Apr 15, 1999

Anyone managed to get the OLAP server installed onto SQL7 Desktop?

I'm running it on Win98 and the installation only offers the Client and sample applications.

Obviously the client won't connect as there's no server to connect to.

The documentation on what does/doesn't run in Desktop version doesn't mention OLAP server.

Please email reply to me at RussLewis@msn.com

Thanks

View 1 Replies View Related

OLAP Services

Mar 2, 1999

I have installed OLAP services along with SQL Server 7.0. I want to use the sample MDX application supplied with the CD. When I try to use the dsample application, it comes up with a dialog to enter the server name and gives me an error unable to connect to the OLAP server.
My computer is Windows 98. Do I need to install OLAP Server ? If so how ?

Thank you

View 1 Replies View Related

OLAP License?

Mar 8, 2001

I can't find anything written about licensing for OLAP anywhere. Do I presume correctly that it doesn't require one of its own?

Thanks for any info.

Simon

View 3 Replies View Related

OLAP And Excel

Jun 6, 2001

I keep getting this error when trying to connect users to the OLAP server from
Excel.

"Unable to open connection.
Cannot Connect to server 'OLAP Server Name'.
OLAP server error: The operation failed due to network problems."

When I use this excel locally on my machine it works just fine. Any ideas?

View 1 Replies View Related

OLAP Tools?

Oct 4, 2004

So I am starting to look at an OLAP problem having been an OLTP DB wonk for several years.

All very nice. Am bending my head aorund cubes and the dimensions trciks and learing to choose them more carefully.

Have wokred through the various chapters of various SQL books (OLTP books with a couple of chapters of OLAP I admit) and am starting to feel if not comfortable with it at leats not compleetly terrified.

Now the Analysis manager in SQL is all well and good but I'm not about to hand it to the accounting monkeys that work here.

Does anyone have any suggetsions of some good OLAP specific books and any Cube viewing tools/suites/utilities that I can give to the computer-illiterate bean counters I work for?

many thanks

Steve

View 2 Replies View Related

OLAP Security

Jul 17, 2006

Hello DBForums

View 1 Replies View Related

OLAP Testing

Jan 15, 2007

Hi Guyz ,

I'm new to this forum and as well as new to OLAP testing . I would like to know OLAP testing and guidance for SQL server anlaysis services .

I have been trying install SQL server 2000 in my system but it not going through, Can anybody send information how to install SQL server and how to play with sample database.

View 2 Replies View Related

OLAP Problem!

May 31, 2007

I'm trying to retrieve calculated members from a cube using the OPENQUERY function and a OLAP linked server, the results from MDX Queries are then stored to a SQL Server DB Table.

below is the error message I get:

Could not get the data of the row from the OLE DB provider 'MSOLAP'.
OLE DB error trace [OLE/DB Provider 'MSOLAP' IRowset::GetData returned 0x80040e21: Data status returned from the provider: [COLUMN_NAME=[Measures].[first column] STATUS=DBSTATUS_E_UNAVAILABLE], [COLUMN_NAME=[Measures].[second column] STATUS=DBSTATUS_E_UNAVAILABLE]]

When I run the same query in MDX Sample Application it works fine!

Any help Please!

View 2 Replies View Related

Oltp && Olap

Dec 19, 2007

hello everyone,

Is it make sense to create 2 databases, OLTP for the insert, update and delete and OLAP for selection
and i'll sync between the 2 databases.

Thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved