DSXchange

Please help, I have store procedure in SQL server, which use the open query. When i run the job which triggered the store procedure by ODBC stage i get the error :" IF9MIF_CCP_CallProc..MSSQL_SP.CheckStatusSp: DSD.BCIOpenR call to SQLExecDirect failed. Statement was:{call Phone_Directory.dbo.U...

Hi, Can you use search and replace on a dsx export file? IHTH, In fact when you write in the server mail subsection of the Email Object in 7.1 : "":SmtpServer:"" , the code generated is "\nServer:":SmtpServer:"\nBody ... So you don't need to replace anything in th...

What about 'the DSSENDMAIL' doesn't work? You really should start a new post rather than jump on the end of an old one so we have some clue what your specs are. What operating system? Hello, I have started a new post 'DSSENDMAIL upgrade 7.1 to 7.5 ' like you said. Have you got some solutions ? Than...

Hi, We just have upgraded to 7.5 version in windows system. And my problem is : we used parameters in job sequence with the Email object (this way for example: "": SmtpServer :"" ) and when we had imported our jobs in the 7.5 version, and ran it : the jobs abort if they need to s...

Yeah , I have the same problem , The DSSENDMAIL doesn't support to attach parameters in it. I dont know wht can be the workout. You can use parameters with DSSENDMAIL in 7.1 version , for example in the body you can write : "Rejects in file ": SrcDir:FileName:"." or in the Smtp ...