This is a discussion on DTS-Package sends mail and files before the job finishes within the SQL Server forums, part of the Microsoft SQL Server category; --> I have a package which truncates files, fills them with data and should send a mail with the files ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| 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@gmx.net> wrote in message news:24638df5-4feb-4d7f-9608-3d828241b8df@l16g2000hsf.googlegroups.com... >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 |
| Thread Tools | |
| Display Modes | |
|
|