DSXchange

Hi Craig, We have actually checked the jobs thoroughly and have found no anomalies. We replaced the SQL Bulk Loader Stage with an ODBC Stage and the job loaded the data in a perfect fashion. Therefore was considering whether there is any specific issue with the SQL Bulk loader stage? :? Thanks and R...

Hello All, We are facing a very peculiar issue on our production environment when we use the SQLSvr Bulk loader. We recently added a new column to an existing table and made relevant changes in our server job. An entry for the new column was made in all the relevant stages. There are around 200,000 ...

Hi All, We are having a large set of sequence jobs which we schedule to run during our overnight processing. There are instances when one of the server jobs fail. At present we create a copy of the sequence, remove the server jobs which have run successfully and reschedule the sequence to run again....

Thanks for all the responses. The problem we are stuck up right now is that we have single user access to all, and thus there are accidenental amendements which take place on server jobs during issues investigation. Right now we are looking at two different roles on the environment: 1. Production Su...

Thanks for the welcome Kumar. :D Well you could consider it as my naivity in Datastage, but i am unable to understand the use of dsadm. At present the datastage server is hosted on a Windows 2003 server and we have assigned the three roles available in datastage to the various windows user groups. H...

We are trying to implement access control policy on our production environment. We have been exploring two options as of now: 1. Releaseing jobs and thus creating read only jobs. 2. Protecing a project. However both these options does not allow us to have a staged access policy. What we are aiming a...