• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Component tMSSqlSP with non existing stored procedure

#1 2011-02-18 09:51:20

Jilles
Guest

Component tMSSqlSP with non existing stored procedure

In my Talend job I use the tMSSqlSP component. I call a non exisiting sp but am not able to stop the flow of the job. How do i perform this?
If I call a existing stored procedure, also the stored procedure doesn't show up in my sql trace, but no error received.

Using TOS 4.0.1

#2 2011-02-18 09:59:43

shong
Talend team
Registered: 2007-08-29
Posts: 10357
Website

Re: Component tMSSqlSP with non existing stored procedure

Hi
It is abnormal, it will throws an error if the sp does not exist. Please upload a screenshot of your job.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2011-02-18 15:29:44

limsuser
Member
Registered: 2010-03-24
Posts: 14

Re: Component tMSSqlSP with non existing stored procedure

attached screenshot


Uploaded Images

Offline

#4 2011-02-21 05:09:53

shong
Talend team
Registered: 2007-08-29
Posts: 10357
Website

Re: Component tMSSqlSP with non existing stored procedure

Hi
Do the job parallel run? From the image, I see the tMSSQLSP run fine and displays 'onSubjobOK', is there any logic error in your job? I suggest you to test it again on latest version TOS412.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Component tMSSqlSP with non existing stored procedure

Board footer

Powered by FluxBB