DSXchange

Thank for the replies All, After some "changes"/recompiles and such it started working. I'll try clearing the ststus file Ray next time , I still need to verify this being persistant and not a random fluke now and then. (yes you got the idea Sainath.Srinivasan, I can't recall if it did , if I get th...

Hi, Sounds like your ventring down the basic code. FTP Stage is kinda resonable for relatively small ascii files since it goes and reads the file on hte remote server. for heavy duty ftp tasks you'r better off building a dynamic ftp file and running a command line to get the files. you can also dele...

Hi, Do you mean you have the same sequence job in several projects and only in one it takes 5 minutes to load the job design? (is that project on the same disk/storage as the other ones? - I guess not) Or do you simply have a single huge sequence job that takes very long to load? (Try breaking it do...

Hi, I have a DRS performing select max for a column to a Xfm poping a user status and outputing to /dev/null. it was working fine till recently we started getting the above message and the job aborts. (searcing for the entire error got 4 results all leading to a forum page but no real post). Thanks ...

Hi,
What security concern you had in mind?
Enough to say you'll need to supply all parameters including server,user,password to get the export.
So restrict the access to that machine.
By the way I think you'll find it's almost impossible to gaurd againt your gardian

IHTH,

Hi,
I used search to find
"STAGE has unexpected STATUS value"
related posts.
I got 4 results.
clicking any of them got me to a dead end (a forum page not a post)

Hi, When I import a date column I get a timestamp in my table definition I used a transform: (Oconv(@DATE, "D-YMD[4,2,2]") : " " : Oconv(@TIME, "MTS")) to load my job's start date. I'm working with oci 8 libraries though. IHTH,

Hi, You can : 1. use a parameter value. 2. code it yourself, I'll explain: you have: ErrCode = DSSetParam(hJob1, "CURRENTMONTH", "PrevioudMonth") if you'll code a variable to hold the value in question you can use: ErrCode = DSSetParam(hJob1, "CURRENTMONTH", myVariable) myVariable can be a parameter...

Hi, I'd say you can simply prevent access to the production project. 1 way might be: using a protected project means you can't promot via version control to it till you unprotect it. keeping that in mind having the DS admin's password on your production server means no one can unprotect it if they k...

Hi, Late last year I attended a course at Ascential FR. They said it sould be available eventually as a 1 day activity, for those who want it; though they knew not of a specific date they guessed not befor 2005 I guess with all that has happened maybe the plans were changed / postponed . Keeping in ...

Hi,
In my experiance so far lookup file set are faster.
The down side is having no view for the stored data.
And the Modify stage you need for changing column names.

I don't recall exact numbers right now but if you like I can get some.

IHTH,

Hi, this is not a trivial thing to answer since only you have all the vriables Befor you think of consolidating projects you must verify no objects are identical by name, If they are and perform different functionality you'll need changes made. If you ment dev+prod project foreach 7 projects you mig...

Hi,
I recommend also asking DBAs is there a setting in the DB level that may control this behaviour.

IHTH,

Hi,
As I understand what you qouted,
It is only a way to double the size of the buffer the operators use.
It has no relevance to 32bit/64bit machine.

IHTH,

Kinda makes you wonder how to get that DSX cutter utility no?

(some how a colegue made me think they did something similar, but maybe the individual dsx files were actually manually made at dev time?! )

I'll have to check it again...