MS SQL Server MSEQ - TEXT Files

Author

TEXT Files

2005-05-03, 7:24 am

Hi,

FYI, all about SQL is new to me. I would appreciate it if someone could help
me on
the following :-

1) I have one text file containing 8 fields separated by pipes (|) and 1000
of rows
eg:-
Chang|Michael|acno12
34566|03052005|154.26|1|0|655426.26
- Is it possible to import the above kind of text files by using the
query analyzer
(transact-SQL) without using DTS into the following table format.
nvarchar|nvarchar|nv
archar|dd/MM/ yyyy|decimal|logical
|logical|decimal
- If yes, please help/show me the samples and how can I execute it from
dos
prompt by using command line.
- If no, I have to use DTS. How to execute DTS against the above data
using
command line.

TQ.

Beginner...

Hugo Kornelis

2005-05-09, 8:24 pm

On Tue, 3 May 2005 04:57:02 -0700, GW wrote:

>Hi,
>
>FYI, all about SQL is new to me. I would appreciate it if someone could help
>me on
>the following :-
>
>1) I have one text file containing 8 fields separated by pipes (|) and 1000
>of rows
> eg:-
> Chang|Michael|acno12
34566|03052005|154.26|1|0|655426.26
> - Is it possible to import the above kind of text files by using the
>query analyzer
> (transact-SQL) without using DTS into the following table format.
> nvarchar|nvarchar|nv
archar|dd/MM/ yyyy|decimal|logical
|logical|decimal
> - If yes, please help/show me the samples and how can I execute it from
>dos
> prompt by using command line.

Hi GW,

You might wish to check out the descriptions of the BULK INSERT command
and the bcp.exe tool in Books Online. In fact, one of the examples in
the BULK INSERT description looks almost made for this issue.

> - If no, I have to use DTS. How to execute DTS against the above data
>using
> command line.

For help with DTS, your best bet is to visit the group that is devoted
to DTS: microsoft.public.sqlserver.dts.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Sponsored Links