DSXchange

Hi,
Is there any way a job can implement NT Authentcation rather than having to submit a username and password to access MS SQL Server?
Thanks.

Hi, I have an odbc stage where I firstly want to delete records which are resident within the input based on a particular field and then insert them. The SQL is; DELETE FROM db_UK_Directory.dbo.tbl_Contact WHERE intOUID = intOUID; INSERT INTO db_UK_Directory.dbo.tbl_Contact(intOUId, vchrFunction, vc...

Thanks, I will try some of those and get back to you.

hi, I'm sure there is a very simple answer to this but I am going to ask anyway. I have a comma delimited file which has five fields per line. However, on some lines several fields can be missing (even the commas) and the job won't run. This is what the job log tells me, 'A2000_PopulatePCMTable..PCM...

I think that you are missing the point battaliou. My remit is to transpose a host of dts packages from SQL Server into Ascential datastage. The reaoning behind this are a range of high level audit and securiity issues. I could also use a similar implementation as you are describing but this would be...

Thank you, that was very helpful.

You may have noticed that I am using a UNIX implementation of Datstage and do not have direct access to osql. Are you suggesting that I write a shell script that remotely calls a script on the database server that runs osql. If you could tell me how to do this and give me the code, I would be very g...

Yes, I know that you can call an sp throuugh an ODBC stage but what if you just want the stage do conduct a piece of SQL work i.e truncate a table, drop a table, create a table, etc rather than using the sp to output data.

Thanks. I was just wondering whether it would be a sensible idea to have a section within the forum on known issues/things you can't do within the Datastage family of products. This would help people like me, who are fairly new to the application from spending hours searching for answers where there...

If the drivers are available to Ascential through DataDirect, why don't they port with Datastage? Datadirect have obviously seen the requirement as they wouldn't have bothered writing the sequelink drivers in the first place. Sorry, I am just a bit vexed that I and my colleague have to spend days tr...

Does the stored procedure stage suepport SQL Server. The only database vendor I can access is ORACLE. If this is the case, is there any other way of running SQL without having to define any input or output.

Hi, I was just wondering if you managed to resolve your connection problems. I am having the same issues and have been trawling the web for an answer. The best I have come up with, are the Sequelink set of drivers from Datadirect (who actually provide the ODBC drivers for Datastage) but at quite a c...