Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2003-02-24 : 10:28:34
|
| Hi folks,I have an activexscript task in DTS which checks for File Size. In case the file size is less than 100 bytes I want to send an e-mailnotification and stop further processing of the package. in case the file size is greater than 100 bytes, iw ant to proceed with a datapump task taking data from text file into sql server.I have evry thing set up in DTS, but when the activex script tasks fails I am not able to get the failure workflow to work. Any ideas.Ramdas NarayananSQL Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-24 : 12:48:16
|
| Does the activex script fail the task when the file size is less than 100 bytes? To fail the task, add this in your if clause that checks if the file size is less than 100 bytes: Main = DTSTaskExecResult_Failure. |
 |
|
|
|
|
|
Check File Size