DSXchange

I tested the DSN connection to the SQL server database using odbcping and it connected successfully. So there is no problem with the DSN configuration. Any pointers please? Try hardcoding the properties.Dont use DSN Server Name: XXXX (Physical Server Name) Database Name:XXXX (DB name on the server)...

Naveen,

Thanks for the suggestion, i tried lookig for help in sql server but could not find any.

Satya

I am trying to do an UPDATE STATISTICS calling a Stored Procedure in ODBC using DataStage. This has to be done after my sequence loads all the tables.The Stored Procedure runs fine updating all the Tables in the SQL Server Query Analyzer, well it is throwing a warning message when i run the DataStag...

I have encountered an unsual problem with a sequnce job. I designed a sequence as follows: S1 | | S2 | | Routine------------------------> S3---->S6 \ ->S4----------> S5 My goal is to run the sequence with the routine activity to run the job S1->S2--> Routine -->S4 (S4 and S5 section shown above) for...

Hello, I have a strange problem with respect to the wait for file activity: i am trying to write to a sequential file from a table giving the status of the job sucessfully run or not, i put the constraint on the trnsformer that if the count(status)=0 write to the file with single column as "suc...