SQL and Exchange Table

(0) Share

Report

Posted on by Irwin Tang

210

I am trying to find a way to automate daily exchange rates into GP.

It is ok to do it in SQL and not through integration manager? IE. setup some procedures to just insert the rates into the table? What will that DEX_ROW_ID column be filled with?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Suggested answer

Community Member on at

Like (0)

Report

Re: SQL and Exchange Table

We have a free product to import exchange rate feeds, please take a look into the below and let me know if you are interested:

mohdaoud.blogspot.com/.../currency-exchange-rates-feed-importer_4319.html

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

Re: SQL and Exchange Table

Hi Irwin,

I think you'll be fine by populating the table directly. It's commonly done this way in my world.

Kind regards,

Leslie

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Re: SQL and Exchange Table

Hi Irwin,

You should not have to specify a value for the Dex_Row_ID column because they are managed automatically by SQL Server.

Hope this helps.

Adam

Was this reply helpful? Yes No