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>
Organization: http://groups.google.com/
Subject:      How to upload 140 millions of record  from SAS To SQL server
              table(single)
Content-Type: text/plain; charset=ISO-8859-1

Hi

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

Kavitha