Web Development

Ask something
Discussion Locked

Support required for SQL Server 2000

0 helpful
2 replies

by arif9000

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

Would really appreciate if some one can help me in developing code
for loading data from 2-3 source files (text format) into SQL server.

o Pls. find attach the scripts & the data
o Your support would highly be appreciated.
----------------------------------------------------------

1. Table structure:
CREATE TABLE temp
(
column1 varchar(11) NOT NULL,
column2 varchar(11) NOT NULL,
)

----------------------------------------------------------
2. Bulk Insert query (coyingone source file into table)
BULK INSERT Billing.dbo.cust
FROM
'c:\a.txt'
WITH
(
FIELDTERMINATOR = ',',
)

Result: [this was successfully implemented)

----------------------------------------------------------
3. Problem Area (copying three source files into one table)
BULK INSERT Billing.dbo.cust
FROM
'c:\a.txt'
'c:\b.txt'
'c:\c.txt'
WITH
(
FIELDTERMINATOR = ',',
)

Result: [Errors)

----------------------------------------------------------

PLEASE HELP ME

2 replies

by vinnyd

You need 3 lines to do this code like this:

BULK INSERT Billing.dbo.cust
FROM
'c:\a.txt'
WITH
(
FIELDTERMINATOR = ',',
BULK INSERT Billing.dbo.cust
FROM
'c:\b.txt'
WITH
(
FIELDTERMINATOR = ',',
BULK INSERT Billing.dbo.cust
FROM
'c:\c.txt'
WITH
(
FIELDTERMINATOR = ',',

The insert command can only use one "source" for input at a time.

This discussion is closed to new replies.