"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uroLeOw7EHA.1300@TK2MSFTNGP14.phx.gbl...
> If time is an issue then by far the quickest way is to use BULK INSERT
(Task or statement)
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - SQL Server 2005 Integration Services.
> www.Konesans.com
>
>
> "Higgim Batham" <HBathamMail@hotmail.com> wrote in message
news:%235pvkst7EHA.3840@tk2msftngp13.phx.gbl...
> > Currently I am loading a table by reading a flat file.
> > Since I am loading more than 5 million records it is taking some time to
> > load the data. I am using DTS package to read the data.
> > Is there any alternative(other than DTs package) to read the data from
flat
> > file and to load the data into the table in SQL.
> > I am using SQL2K.
> > Batham
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:eCvzEKd8EHA.2016@TK2MSFTNGP15.phx.gbl...
> BULK INSERT exists as a TSQL statement and as a DTS task (Wrapper around
the statement). It is by far the fastest method of loading
> a text file into SQL Server
>
> Have a look in BOL here
>
>
>

>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - SQL Server 2005 Integration Services.
> www.Konesans.com
>
>
> "Higgim Batham" <HBathamMail@hotmail.com> wrote in message
news:eJuwsJc8EHA.1392@tk2msftngp13.phx.gbl...
> > Allan,
> > Thanks for the reply.
> > What sence you are referring "BULK INSERT". Is it like with one SQL
insert
> > which inserts so many records at one time. OR is there any "BULK
INSERT"
> > concept is there? Can you please explain me what you meant by "BULK
INSERT".
> > Thanks,
> > Higgim
> >
> > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> > news:uroLeOw7EHA.1300@TK2MSFTNGP14.phx.gbl...
> >> If time is an issue then by far the quickest way is to use BULK INSERT
> > (Task or statement)
> >>
> >> --
> >>
> >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> >> www.SQLDTS.com - The site for all your DTS needs.
> >> www.SQLIS.com - SQL Server 2005 Integration Services.
> >> www.Konesans.com
> >>
> >>
> >> "Higgim Batham" <HBathamMail@hotmail.com> wrote in message
> > news:%235pvkst7EHA.3840@tk2msftngp13.phx.gbl...
> >> > Currently I am loading a table by reading a flat file.
> >> > Since I am loading more than 5 million records it is taking some time
to
> >> > load the data. I am using DTS package to read the data.
> >> > Is there any alternative(other than DTs package) to read the data
from
> > flat
> >> > file and to load the data into the table in SQL.
> >> > I am using SQL2K.
> >> > Batham
> >> >
> >> >
> >>
> >>
> >
> >
>
>

"Higgim Batham" <HBathamMail@hotmail.com> wrote in message news:eJuwsJc8EHA.1392@tk2msftngp13.phx.gbl...
> Allan,
> Thanks for the reply.
> What sence you are referring "BULK INSERT". Is it like with one SQL insert
> which inserts so many records at one time. OR is there any "BULK INSERT"
> concept is there? Can you please explain me what you meant by "BULK INSERT".
> Thanks,
> Higgim
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:uroLeOw7EHA.1300@TK2MSFTNGP14.phx.gbl...
>> If time is an issue then by far the quickest way is to use BULK INSERT
> (Task or statement)
>>
>> --
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.SQLIS.com - SQL Server 2005 Integration Services.
>> www.Konesans.com
>>
>>
>> "Higgim Batham" <HBathamMail@hotmail.com> wrote in message
> news:%235pvkst7EHA.3840@tk2msftngp13.phx.gbl...
>> > Currently I am loading a table by reading a flat file.
>> > Since I am loading more than 5 million records it is taking some time to
>> > load the data. I am using DTS package to read the data.
>> > Is there any alternative(other than DTs package) to read the data from
> flat
>> > file and to load the data into the table in SQL.
>> > I am using SQL2K.
>> > Batham
>> >
>> >
>>
>>
>
>