LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 28 Oct 2002 10:52:48 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: How to upload 140 millions of record  from SAS To SQL server
Comments: To: kavitha <kavitha.subramani@GEIND.GE.COM>
Content-type: text/plain; charset=iso-8859-1

I looks like DTS concept might take more than 30 hours. How often would you need to perform this 140M load? How long were your sas programs taking to run in total ?

The first thing that comes to my mind is parallelising the I/O. Would DTS concept help with that? SAS can.

To let us judge how your sas programs can be improved. please post samples of the sas code to sas-L

HTH Peter Crawford

Datum: 28/10/2002 07:22 An: SAS-L@LISTSERV.UGA.EDU

Antwort an: kavitha <kavitha.subramani@GEIND.GE.COM>

Betreff: How to upload 140 millions of record from SAS To SQL server table(single) Nachrichtentext:


I have converted 140 millions of record from flat text files into SAS data set using SAS Program. As the performance is not good in SAS i would like to upload these SAS data directly into single table in SQL Server. And i want to know how many hours will it take to upload. Actually im trying this uploading thro DTS concept in SQL server. It is taking 1hour to upload around 4millions of record.

Please let me knw how to do this efficiently. Waiting for your reply.

Thanks in advance



Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Back to: Top of message | Previous page | Main SAS-L page