Unable to run stored procedure on IN-DB Connect/Data Stream Output

[Frantically]

Hiyo,

No idea if this has been asked before but I'm having issues with running stored procedures through the Ole DB Provider for SQL Server.

On the attached image, it says there's an invalid object name but the stored procedure does exist and it looks like it's trying to select it as if it's a table. It works fine when I select a normal table but not when I execute stored procedures. Is there any way I can get the stored procedure to execute, if possible?

Thanks!

[gabrielvilella]

I don't think it is possible to run stored procedures using the In-DB tools. It is possible to call them if you have a regular Input/Output data tool within the pre/post SQL statement area.

[Frantically]

Looks like it, yep. Thanks for the reply!