Confirmation on Script Task Behavior

Hello,

I am looking for some confirmation on a behavior of the SSIS Script Task. I have a custom script task that takes an input file, and archives it after it has been processed into the database.

When I run this package in the Visual Studio GUI, if the destination drive is full, it throws an exception telling me that there is not enough disk space. So, my questions are:

1) If this happens when the package is running through the command line, would this exception still be thrown? (I am thinking it will be)

2) Also, Do I need to explicitly fail the script task in the event handler, in order to ensure this .Net exception being thrown will cause the component to fail. (I am fairly certain I do, since this is what I had to do inside of the Visual Studio GUI, but does anyone know if this same behavior would occur when running from the command line?)

Thanks,

Chris

If you don't catch the exception, it should cause your script task to fail. Otherwise, you would need to explicitly fail it by setting Dts.TaskResult=Dts.Results.Failure. The exception-related behavior will be the same between the GUI and the command-line.

configuring smtp connection on dts in VS2005

I'm trying to send mail through DTS Send Mail Task in the final release of VS 2005 however i'm getting this error "Mailbox unavailable.The server response was:5.7.1 Unable to relay for <email adress>.

I do not have exchange server installed. The smtp adress is correct. So what could be the problem?

I appreciate your help

Thanks

Network issues

Incorrect address

DNS failure

Authentication failure

etc...

The list of things that it COULD be are endless. Presumably you think that the problem exists somewhere in SSIS. Have you removed SSIS from the equation and see if it works then?

There isn't really enough information in your post to diagnise what the problem may be.

-Jamie

|||Christina,
The error message you are receiving indicates that the mail server you are trying to send mail through does not allow relaying. This is the usual setup for mail servers to cut down on spammers sending email through legitimate mail servers.
I would contact the administrator of the mail server you are trying to attach to and see if he can setup relaying for your SSIS box or email account.
Larry

|||

has anything changed in the configuration of the ssis send mail task? because in the beta version (before i moved to the final release) it was sending normally without any errors.

i can ask the smtp provider to allow relaying but that would be risky as you said.

thanks and happy new year

|||

i checked with the mail server administrator and relaying from the email address i'm using is allowed. so it's not an issue of relaying.

i also tested sending a test email from command prompt using smtp commands and it sent the mail normally. however from sql i still get the relaying error.

any clue?

thanks

|||

problem is solved. i used a different smtp server and unchecked the "use windows authentication" in the smtp connection manager. i thought it wouldn't matter since i didnt have exchange server. but it seems to have counted.

thanks to all

Christina