General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Support required for SQL Server 2000
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