Date: Sun, 27 Oct 2002 23:14:26 -0800
Reply-To: kavitha <kavitha.subramani@GEIND.GE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: kavitha <kavitha.subramani@GEIND.GE.COM>
Subject: How to upload 140 millions of record from SAS To SQL server
Content-Type: text/plain; charset=ISO-8859-1
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