|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Load comma delimited file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Load comma delimited file
|
|
|
| Thanks for all the replies. Based on the responses I've
been playing with DTS, BCP Utility and Bulk Insert. Bulk
Insert works well based on my tests but it seems to be
limited to one table per file. Is there anyway, using
any of these 3 methods, to read 1 row at a time from the
file and do some logic and then put the data into
different tables based on the logic?
Thanks again.
>-----Original Message-----
>I have to load a comma delimited file into SQL Server 2
>times a week. Do I have to write a VB app to parse the
>data and run a bunch of inserts or is there some kind of
>functionality within SQL Server that could handle this?
>
>Thanks,
>Darin
>.
>
| |
| msnews 2002-11-20, 4:23 pm |
| With dts you can have a vb or sql munge the data and load into the proper
tables. Basically dts starts the job and knows where the text file is and
what tables it will be loading, but relies on the sql or vb to transform the
data. Run through the dts wizard to see what I am talking about. When you
get to the tables (source and destination screen) click the transform
button.
"Darin" <dvanatta@edgewater.com> wrote in message
news:be4401c290c3$0d60b7e0$8df
82ecf@TK2MSFTNGXA02...
> Thanks for all the replies. Based on the responses I've
> been playing with DTS, BCP Utility and Bulk Insert. Bulk
> Insert works well based on my tests but it seems to be
> limited to one table per file. Is there anyway, using
> any of these 3 methods, to read 1 row at a time from the
> file and do some logic and then put the data into
> different tables based on the logic?
>
> Thanks again.
>
> >-----Original Message-----
> >I have to load a comma delimited file into SQL Server 2
> >times a week. Do I have to write a VB app to parse the
> >data and run a bunch of inserts or is there some kind of
> >functionality within SQL Server that could handle this?
> >
> >Thanks,
> >Darin
> >.
> >
|
|
|
|
|