473,503 Members | 1,877 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
Dec 11 '07 #1
1 1304
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" <hm***@gmx.netwrote in message
news:24**********************************@l16g2000 hsf.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

Jan 11 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3634
by: David Greenberg | last post by:
Hi ! I know how to save a DTS as a structured storage file and how to recreate a DTS using that file. What I can't find is a command, either in t-sql or from a DOS level, with which I can save...
3
8278
by: xMANIGHTx | last post by:
I'm new to DTS. I read some docs before adventuring into this matter. I still haven't found in all the docs I read if there is some "built-in" DTS task or function or wathever, to do a mixed...
1
1617
by: Alex | last post by:
Hi all, I bet this doesn't exist, but does anyone know of an MS SQL Enterprise Manager-type application for Linux that would give me access to a DTS stored on the server? I'm a web programmer...
1
1874
by: Trent | last post by:
Hello, folks. I'm searching for some good must-have books on SQL Server DTS. If you are in the DTS business daily, you probably know which books are good for DTS. I can browse some online book...
1
1525
by: Geetha | last post by:
Create a table (each time different table) – we have a DTS to do that -- 1 There is a fixed delimited text file; we need to Import this file into the created table above and we have another DTS to...
3
3653
by: Elaksomfan | last post by:
Hi, I am having trouble importing data from an excel spreadsheet into MS SQL Server 2000 using DTS Wizard. The DTS import process is successfull, no errors, but only 50 rows of approx. 1500 rows...
1
1862
by: RSH | last post by:
Hi, I am deep into creating a VB .Net application that basically creates SQL Server versions of our Access databases and copies over all the data. I Extracted the VB DTS script and brought it...
0
2065
by: chris.feyrer | last post by:
I need to export data from SQL server 2000 (or SQL server 2005 with a db connection to the SQL 2000 server) to a DB4 file via DTS. When I use Windows 2000 server to attempt the export, I keep...
2
22836
by: Bill_DBA | last post by:
I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug messages. The second, when equals 1, turns on the...
4
9145
by: othellomy | last post by:
Why is dts packages out of server 2005? In server 2k they were there but in 2005 it's gone? I tried to connect to 2k using 2005 client interface and can't seem to locate the dts packages I seem to...
0
7091
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7342
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6998
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7464
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5018
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4680
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1516
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
741
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
391
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.