dbTalk Databases Forums  

Problems DTS Bulk Copy

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Problems DTS Bulk Copy in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ricardo Rodrigues
 
Posts: n/a

Default Problems DTS Bulk Copy - 09-09-2003 , 11:23 AM






Hi,

I have a DTS Package (.bas) that I run from VB 6.0. So,
after many loads successfully. Now I'm receiving a follow
message:

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.

Somebody know this problem.

Thank you


Reply With Quote
  #2  
Old   
Karthik Nagaraj
 
Posts: n/a

Default Re: Problems DTS Bulk Copy - 09-09-2003 , 11:42 AM






Hello Ricardo,

Your process likely got blocked by another process like the backup of the
database you are working on.


"Ricardo Rodrigues" <rc.rodrigues (AT) uol (DOT) com.br> wrote

Quote:
Hi,

I have a DTS Package (.bas) that I run from VB 6.0. So,
after many loads successfully. Now I'm receiving a follow
message:

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.

Somebody know this problem.

Thank you




Reply With Quote
  #3  
Old   
Ricardo
 
Posts: n/a

Default Re: Problems DTS Bulk Copy - 09-09-2003 , 12:02 PM



Hello,

Thank you.


Quote:
-----Original Message-----
Hello Ricardo,

Your process likely got blocked by another process like
the backup of the
database you are working on.


"Ricardo Rodrigues" <rc.rodrigues (AT) uol (DOT) com.br> wrote in
message
news:013501c376ee$c0f4ab60$a301280a (AT) phx (DOT) gbl...
Hi,

I have a DTS Package (.bas) that I run from VB 6.0. So,
after many loads successfully. Now I'm receiving a
follow
message:

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.

Somebody know this problem.

Thank you



.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.