You're right, Peter  . 

Raiserror would be a nicer way of handling it.

Bill

I recently had an unrelated problem (nul ASCII characters in the text file that confused DTS about the end of the row).  My solution was to read it in line...

I must have missed something .  I thought you simply wanted to send the email if your proc failed.

If you want the DTS task to...

Unless you really need the email part in a separate task, just use something like this in the original Execute SQL task:

declare @err int

EXEC my_proc

set @err=@@error

--NOTE:@@ERROR returns the number...

I haven't tried using a GV for pkg name, but this should do what you want.

(In ActiveX task):

...

SET  oPkg = CreateObject("DTS.Package")

' get child pkg....

For another option, see proc listed here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=102069#bm102395

Use Execute Process Task in DTS. 

Win32 Process: C:\Program Files\Microsoft Office\Office10\EXCEL.EXE

Parameters: c:\File.xls

This will open the file and allow you to view or manipulate data.  The DTS package will not continue until you...

Vad4,

Here's a proc to "put" files:

--From posting by edk89 on sqlservercentral.com 12/09/2002       

--Subsequently modified by Bill Nye 9/29/03 to include servername (for other than default instance) and...

What about using the DTS FTP task with on success/failure, especially since you're already using DTS?

Alternatively, if you want to check if the file is there, you could use...

Perhaps this will help.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=16878   (re: SQLServer/Outlook).

Bill

Thanks for the replies Phill and FPerkins.

Fortunately, the vendor (after a couple of attempts to sort out field mappings) has been able to provide me with converted data.

In the meantime,...