Hello,
Is it prossible to combine field value when doing bulk insert?? And
how?thanks
Edwin
by Edwin Ma » Sat, 04 Sep 1999 04:00:00
Edwin
by Steve Robinso » Sat, 04 Sep 1999 04:00:00
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.
>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/
3. BULK insert not giving sequential IDENTITY numbers to a field
5. BULK INSERT and TimeStamp field
7. bulk insert to char(>255) field
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?