DSXchange

Off the top of my head, an "out of the box" solution would be to enable the "include status" option in the email. That would list all of the stages in the sequence, noting which ones succeeded and which ones failed.

Not sure how anyone could help - without you posting your script we'd just be guessing.

As noted, there can be four arguments passed to the Field function, check the documentation. That optional one would be helpful here.

As expected, it's a referential integrity constraint violation. I'd double-check that you are in fact sending a NULL in the column in question.

About a third of it...

On the home screen it shows Expires and the date of the expiration... this rather than Expired so I would double-check the date and that you are reading it correctly.

And I'm assuming "User is Active: Yes" is the same as "not expired", which is what Dennis posted for srds2.

Target table.

Thanks Dennis.

I've sent an email to the site owner... hoping that will help.

Exactly... hence my second question.

Didn't mean you weren't clear and you did attempt to include a good amount of detail. I was just trying to point out that sometimes the words people post are perfectly valid but the code behind the words can be faulty. And we hadn't gotten to the "post your code" stage.

Define "minimal transformation" for us, please.

Well... port 22 is for ssh while 23 is for telnet. As already noted: check your firewalls, make sure that port is open.

OK... thought you said you knew how to read the file. Make sure you've located the BASIC Reference Guide and then look up OpenSeq, ReadSeq, WriteSeq & CloseSeq. Those will get you started and then from there you can use DSAttachJob, DSGetJobInfo & DSDetachJob at a minimum to get the statisti...