dbTalk Databases Forums  

DTS-Package sends mail and files before the job finishes

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss DTS-Package sends mail and files before the job finishes in the comp.databases.ms-sqlserver forum.



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

Default DTS-Package sends mail and files before the job finishes - 12-11-2007 , 04:05 AM






I have a package which truncates files, fills them with data and
should send a mail with the files as attachment when it finishes
running. In between, when the task is still running mail is sent with
empty files. When I take a look at the directory (at the end of the
task), where the files are created I find out that the files are not
empty.

(e.g. in task: doA->doB->doC->SendMail. But instead of waiting till
doB->doC finishes, it does the following: doA->SendMail ... may be
because doB takes long.)

Can I indicate anywhere that it should delay the mail until at the end
of the task?

Thanks in advance.
Harp

Reply With Quote
  #2  
Old   
Jack Vamvas
 
Posts: n/a

Default Re: DTS-Package sends mail and files before the job finishes - 01-11-2008 , 10:33 AM






Do the "->" represent "on Completion" . If so, then what you are saying
shouldn't happen

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com




"harp" <hmetu (AT) gmx (DOT) net> wrote

Quote:
I have a package which truncates files, fills them with data and
should send a mail with the files as attachment when it finishes
running. In between, when the task is still running mail is sent with
empty files. When I take a look at the directory (at the end of the
task), where the files are created I find out that the files are not
empty.

(e.g. in task: doA->doB->doC->SendMail. But instead of waiting till
doB->doC finishes, it does the following: doA->SendMail ... may be
because doB takes long.)

Can I indicate anywhere that it should delay the mail until at the end
of the task?

Thanks in advance.
Harp



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.