DSXchange

Unfortunately, it has been witnessed and discussed before.

Not sure how / if these ever get resolved but it would need to come from the people behind the site.

Back in the day, we ran Sever jobs with a Warning Limit of 1 so this would have blowed us up. Guessing that's not an option for you, hence the previous advice.

As far as I know, you'll need to wrapper it in a custom routine and if the script fails call DSLogFatal().

Probably ODBC. Ask your official support provider.

How exactly are you importing the metadata?

Time to have a chat with your DBA.

Try using IsValid() with the 'decimal' sub-type on the incoming string. The IsValidDecimal() function is something a little different, it's not a shortcut to the other as it might seem.

He posted earlier that he had shut down his site and was working with someone to get it hosted here. Not sure how soon something like that will happen, however.

The information wasn't for us, it was for you. This so you could take them and turn them into what you needed to implement this in the tool. This seems pretty straight-forward to me. Looks to me like you just need to take your termination date and create a pair of dates that encompass the entire mon...

I wanted to note that this was already posted here where how to split the file based on size was already discussed. No need to repeat any of that here.

Why seven? Are you now saying that you need to break this up so each discrete header/footer combination needs to go into its own file?

Then it's not a 'timestamp column', meaning not DATE or TIMESTAMP as you implied but rather a VARCHAR2 string field holding a timestamp value. Correct?

Sure. Write your requirements out in words, that should help with putting together the logic required to accomplish it.

Why not ping your official support provider - I for one would be curious as to the reason why if it isn't supported.

I'd lean towards B at first but there really isn't any way for us to know. If there is a possibility that the 'Load Status Table' job will be triggered simultaneously across your loads then make sure it is a multi-instance job and send something like the table name in as the invocation id.

FranklinE wrote:Use a filter to split the pages into separate files.

So... some kind of awk command in the Filter option?