DSXchange

Sorry again for my late reply. Thanks Andy! I've found another way to get the alerts the way I need. I've replaced the target ODBC Connector with a SQL Server Enterprise stage, which automatically throws an alert for each rejected row. I was trying to avoid SQL Server Enterprise stage because I took...

Hi everyone, Sorry my late reply. Thanks ArndW! I tried your suggestion but it didn't work exactly how you described (certainly I messed something). I used a sequential file as a dummy stage. I set the sequential file's name to an inexistent file and I also set "Append" as "File Updat...

Thank you all for sharing. I tried the message handler approach this way: - Open Director, select the desired job. - Click on menu View > Log - Right click on the "rows rejected" message and choose "Add rule to message handler...". In this case, message ID is "IIS-CONN-DAAPI...

ray.wurlod wrote: Welcome aboard. Thanks ray.wurlod! chulett wrote: Seems to me what they are saying is that is the behavior they are looking for, however it is not generating the warnings. That's right, chulett. I do want the warnings to be generated. The reject reasons are unique key violation. I...

Hi everyone! Please forgive me if my question is too basic, but I'm a newbie. I'm building some ETL jobs for this data warehouse project. Here is the architecture: - DataStage 9.1.2 Machine (Windows 2008 Server 64 bits): engine tier and service tier; - SQL Server 2008 Machine (Windows 2008 Server 64...