DSXchange

Thanks Craig.

Wow, four years??? It's great that you still come here and help out so much.

Actually, it was a quick down-and-dirty routine. Really should have set:
vEventDetail = "" in the beginning.

But, I've run it for a few jobs and I get all entries from the previous run returned. What exactly are you missing?

Like Andy, I would run this from a sequence. You could do something like:

wc -l filename|awk '{print $1}' in an ExecuteCommand. If the CommandOutput > 0, then run your job, otherwise send out a notification email that there was an empty file, or however else you want to handle the situation.

The problem is - you're not listening to what you are being told. First off, when you call DSGetLogEventIds with the 'S' option, you are filtering your results out to just Start and End events, so you are not going to return other log events. Your code uses hJob for the job handle but you use hJob1 ...

Pretty simple. As Craig said, don't have duplicate keys.

I also agree, though if you look at the example, it seems that EmpID is the field that has the embedded carriage returns. One would think that a field such as that would not be free-form text, but you never know. I would suggest getting with the provider of the file and having them clean it up, or y...

Being that a DSX file is a text file, you could export the DSX and an awk program could be written to do what you want.

This topic was from August ... perhaps you might want to start your OWN thread, explain in detail what you are doing, the error you are getting, etc. Just googling the error message gives quite a few pointers - what have you tried, and what have you found? That might be a better way to get some assi...

Rather than using a Numeric Loop type, couldn't you do a List loop with the command output with the delimiter selected as comma?

I do not need to worry about the year after leap year. I compare two dates (to and fro) and if the fro date is less than the to date, then increase the year by one on the fro date. Thanks. But as Craig noted, if you are doing as suggested, you really SHOULD address the leap year issue. If your from...

There are multiple ways to add a year - here is one way (in the example I am just using CurrentDate() ): StringToDate( YearFromDate(CurrentDate())+1:'-':MonthFromDate(CurrentDate()):'-':MonthDayFromDate(CurrentDate())) As to your example, no - it will return a -1. DaysSinceFromDate uses (source date...

chulett wrote:Hmmm... then I wonder why have the ',s' modifier if '%m' or '%d' does the trick?

The 's' option will accept dates that have leading spaces in the date, like '10/ 8/2011 ... %d or %m by itself will choke if there is an embedded space.

If you had the proper ODBC drivers, you would use an ODBC stage to access the Excel data. Check out DataDirect http://www.datadirect.com/products/odbc ... urces.html for UNIX ODBC drivers.

This is the same thing you asked in this thread: viewtopic.php?t=142244 . Why are you posting it again and under a topic heading that is totally misleading?

Devendrudu wrote:Note: my doubt is it's giving same date what i entered in input.

That's probably because the 30th IS a Tuesday, and I believe PreviousWeekdayFromDate includes the source date. If you had specified MON (or Monday), it would have returned the 29th.