Unix Technical Forum

DTS-Package sends mail and files before the job finishes

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 ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-01-2008, 03:45 PM
harp
 
Posts: n/a
Default DTS-Package sends mail and files before the job finishes

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-01-2008, 03:47 PM
Jack Vamvas
 
Posts: n/a
Default Re: DTS-Package sends mail and files before the job finishes

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



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:36 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com