DSXchange

Ray, Thanks for the response. I modified the .bat file a bit so that it would echo the command and pause so I could see the resulting message. The message is as follows: "'dsjob' is not recognized as an internal or external command, operable program or batch file." Does this mean the dsjob...

Chulett, Thanks for the response, I realize my response refreshed the topic...I'd just seen that it had been viewed 3 dozen times without a response to date and figured there just HAD to at least be one other individual that has seen this before. :D Anyway, what I'm saying is that the after sql APPE...

Uh...is there anybody that can suggest an idea on this...? It's been an open topic for almost 2 months but no reply. Still having to manually execute the stored proc after the job is complete.

Any help is much appreciated.

Hello. I have a very simple .bat file with the following DOS commands: @ECHO OFF dsjob -server myServerName -user myUserName -password myPassword -run myProjectname myJobName CLS EXIT When I execute this .bat file on the ETL server via a Remote Desktop Connection, the .bat file executes successfully...

Hello all. I'm having an issue with a very simple job that moves data from one SQL Server 2005 DB to another SQL Server 2005 DB and it looks like this: ODBC ------>XFM------>DRS I'm utilizing the DRS stage in the target because of the need to execute a stored procedure on the target server once data...

chulett,

Thanks a ton! I've emailed Andy and am now in the "finger-crossing" mode, in much anticipation of his response. I will update this thread when/if I hear back from him...either way.

--DC

I'm having this issue as well. I'm the developer so I didn't install and configure DataStage, but I'm the only one that's interested in using the DB2 stage as opposed to ODBC so I'm researching this. Any push in the right direction towards this documentation you mentioned would be much appreciated! ...