DSXchange

The design shoudl be Execute_Command_Activity ------- > Job_Activity In the parameters section, where you apply default values, you are to provide that derivation. Is that your design, if not then can you please draw it out, enclosed in quotes so that it makes sense. Also the part before the .$Comma...

One of the two things, either server address is incorrect or port number is incorrect. Verify them from your dba.

If it is empty then provide the same derivation as earlier, but change the else part to incorporate your timestamp_from_string. Also make sure its a nullable field in your target table.

On the second page.

Same opinion as Craig. Especially if these routines were shipped with the plugins. You'd be better off contacting support.

We need more info samsuf2002. Look into the file and confirm if its the correct format. The length and scale that you posted, is that for the text file or database?

For window, BASIC rules. You should be remembering the post that i embedded in my previous reply. You also posted lines of what was the Grand Father version of WFF stage.

I never got to witness or use any of those so I have no idea what your talking about Ray.
I am at the disposal of my imagination.

You post heading is so tragic

Well use the link partitioner to partition the data into flat files. Use an approximation to how many partitions you need. Then one by one feed it to the stored proc.

Maybe something else is going on in that case. Maybe your timestamp is not in the proper format that timestamp_from_string requires? Possible ???

You must have missed the second page. This is a direct copy paste from there:

Inside the jobactivity, where your specifying $CommandOutput, provide the following

OR simply

Did you read that post that i embedded in my very first reply ?

Yes. The one thats present in the sequence job.

Here's the routine I was talking about:
http://www.dsxchange.com/viewtopic.php?t=100401
Go to the second page. You can remove the timeout part if you want.