News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) GP 2010 Integration Ma...

Microsoft Dynamics GP (Archived)

GP 2010 Integration Manager - Using a stored procedure as a data source

(0) Share

Report

Report

Posted on by Rob.Muschiana

45

I am attempting to use a stored procedure for the integration source and am using an advanced SQL data source, but I am unable to get any columns to return. Is this even possible? Is there a different approach that needs to be taken? I have found lots of examples online on running stored procedures using VB but none of those examples actually use any data returned from the stored procedure. Any help is greatly appreciated! Thanks, -Rob

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2010 Integration Manager - Using a stored procedure as a data source

Ugh sorry I didn't mean a view, I meant a table valued function.
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2010 Integration Manager - Using a stored procedure as a data source

Can you create a view that executes your stored procedure and have it populate a temp table to use as your source.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans