DSXchange

Byron, Simple enough to do with VB or C or C++. I had written a simple VB app which ran as a before job ExecDOS. This preprocess accepted paramters, started Excel (if needed), opened the spreadsheet, did whatever and then saved it as a CSV. Works well and is a fairly simple solution to processing E...

do not give null value to he rest of column, it will cause problem in the future.

I tried the link collector already. It says, "Link Collector Stage does not support in-process active-to-active inputs or outputs" So the only option to put three files into one in a Server Job is to write a Before Job Routine? There isnt a stage to accomplish this? Thanks, Kevin open job...

agree with the above. just add some details
this is from help file
J outputs the day of the year as a number, 1 through 366.
sample :
X = Oconv(10740, "D2*JY") X = "147*97"
conver any date into internal date , then convert back using oconv

what if the colomn is dynamicly changed?

biult two jobs the first one will read the table or file, and load the coloumnName into a hash file . after the job finish, you will get a distinct column name(because hash file will rewrite the value with the same key. in her, key is the column value). this job can also be done in a database. the s...

you can use row merger read the source file into a multi column file then use row merger stage read this file and merg all column into one cloumn. It is easy to use.

I need to load th Error message into a table, how can i get the error message?I have try to use getlogsummary, but always failded
help help