hi all

i need to take csv files to sql server 2000 on daily
basis..............can one help me how to do that....pls

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

DTS is going to be what you need. You found the correct forum so can we
assume you know about DTS?

Design a package to move the csv file into SQL table(s)
Create a SQL Agent job to run the package every day.

Were you looking for detailed help on the DTS Side?
--
Todd C

"sac" wrote:

On Jul 3, 4:10*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:
what do u mean by designing a package? i am not 100% aware
of DTS, but i tried to get CSV file thru DTS, but there is no option
is DTS wizard to take CSV file to SQL SERVER....also what is SQL AGENT
JOB? sorry todd but i am not aware of this....,so pls pls can i
request u to explain me in more detail,,,,or step-by-step....

i wld be really glad....

cheers !!!