import txt into new table

#1

i need to import bunch of text files into SQL server, and i want to
import each file into its own (unexisting) table.

i tried with DTS, it works first time, when i delete tables and try
next time, it complains about unexiting object.

is there any way to make task which creates table each time it is run?
all it needs to do is to create enough varchar(255) columns. DTS do it
first time when i create task, but after that it expects table to be
present in the database.

any workarounds?

thank you!

dario

#2

"Execute SQL Task" containig CREATE TABLE... statement ?

Francesco Anti

<darionis (AT) hotmail (DOT) com> wrote

Quote:

i need to import bunch of text files into SQL server, and i want to
import each file into its own (unexisting) table.

i tried with DTS, it works first time, when i delete tables and try
next time, it complains about unexiting object.

is there any way to make task which creates table each time it is run?
all it needs to do is to create enough varchar(255) columns. DTS do it
first time when i create task, but after that it expects table to be
present in the database.

any workarounds?

thank you!

dario

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

import txt into new table

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

import txt into new table - 07-15-2005 , 08:32 AM

Re: import txt into new table - 07-15-2005 , 09:35 AM