execute stored procedure in Talend - nothing happens

[pawe84]

Hi everyone,

I try to execute a stored procedure which is on a MSSQL Database and called Products_GetList.

The sp by itself will create a product table with 30 columns.

But if I start the job, nothing happens, seems that sp hasn't been executed it.  

Do I have to create a schema?  I don't understand what's the issue in talend, see my example jon below.

Thanks for any advice.

[Anonymous]

Hello,

To test it, try to deactivate tprejob and tpost job and please use tDBSP component only with correct MSSQL DB connection parameter to see if it works?

Best regards

Sabrina

[Anonymous]

Hello,

In addition, if you don't mind, could you please open the error log generated automatically by the Studio to see whether you have error stack trace there; if you do, we will appreciate it a lot if you can paste it here.

About how to open this error log: in your Studio, click Window to open the menu, then select Show View->General->Error Log. Once you see an error, double click it.

Best regards

Sabrina