DSXchange

I have a quick question regarding the actual error log written when a job encounters a truncation message. I have a job that is writing from a hash file to an ODBC stage/SQL database. Usually in the past I have seen the data listed in the director log that is truly the error that caused the truncati...

Just another note on testing now...the above changes I made resulted in about 900 rows/sec until about a million rows were processed. Now it is slowly declining. It is now running about 675 and slowly dropping...but still tons better than it was... anyone know why this would occur or are there just ...

Thanks for the suggestions..I have already incorporated a few and gotten some much better results: --Ref Read hash file is preloaded already because I don't write to it. --Modified the Rows Per Trans to 1000 and array to 350 and it seems to be processing the bulk of the job now at about 800-900 rows...

I have a couple of quick questions for some of the experts. I have done a bunch of searchs and read a lot of posts this morning surrounding this idea. I know there are many parameters so I'll try to be as explicit as possible. I have a basic server job that reads as follows: Hash(type30)-->Trans1 (w...

I just have a quick question that I cannot seem to find any information on. Are there any limitations (documented or found through trial and error) to the naming convention of DS projects? I know that Admin won't let you enter certain characters in a name (or spaces) but are there any other problems...

I have been testing out using an simple ActiveX DLL file to process some data and return info to DataStage but I have a question. I was successful in doing some simple string intepretation and returning a string var to ds...but I was wondering if anyone knows if it is possible to pass parameter valu...

I have a general question...We have jobs built that currently running perfectly for an ODBC connection to a SQL server but they are receiving record lock errors for a select group for an ODBC MS Access conenction. I cannot figure out if Access just handles them differently...? Anyone know if that is...

I have been told by Ascential directly that they do not advise running a project Clean Up...Is this true in your experience?