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