Comine field when bulk insert

Comine field when bulk insert

Post by Edwin Ma » Sat, 04 Sep 1999 04:00:00



Hello,
    Is it prossible to combine field value when doing bulk insert?? And
how?thanks

Edwin

 
 
 

Comine field when bulk insert

Post by Steve Robinso » Sat, 04 Sep 1999 04:00:00


Edwin,

Not as far as i know.  Maybe one solution would be to buult insert into
another table then manipulate the data from there via either updates or
insert statements

I hope this was of use.

Steve Robinson SQL Server MVP.


>Hello,
>    Is it prossible to combine field value when doing bulk insert?? And
>how?thanks

>Edwin


 
 
 

1. Error when bulk insert follows another large bulk insert

I am running a job out of MS SQL Enterprise Manager where the first step
turns off transaction logging, the 2nd step is a large bulk insert step,
and the 3rd step is another large bulk insert step.  I receive the
following error when executing the 3rd step.  Is this error occurring
because the database is still comitting data from the previous large bulk
insert at the same time as it is performing the next bulk insert?  If so,
is there a workaround?  Thank you for any help you can provide.

Error message from Step 3 (2nd bulk insert):
Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation
(such as CREATE FILE) operations on a database must be serialized.
Reissue the statement after the current backup, CHECKALLOC, or
file manipulation operation is completed. [SQLSTATE 42000] (Error 3023)  
The statement has been terminated. [SQLSTATE 01000] (Error 3621).  
The step failed.

--
Posted via CNET Help.com
http://www.help.com/

2. Converting from DataFlex

3. BULK insert not giving sequential IDENTITY numbers to a field

4. connect(..) returns null

5. BULK INSERT and TimeStamp field

6. Open Jobs in San Francisco

7. bulk insert to char(>255) field

8. log shipping sql 2000

9. Replacing empty fields with NULL after a BULK INSERT

10. BULK INSERT with quotes fields

11. Bulk insert, empty string to datetime field?

12. Bulk Insert with a hash as field delimiter

13. Bulk Insert, empty string to datetime field?