SQL Server - Update exchange rates
Asked By strychtur
09-Aug-07 12:05 PM
Hi All,
Right now we get a daily email with the current currency exchange rate
in it. Then someone copies that data into a SQL Sever table every
day. I am looking to automate this process. The source of the exchange
rate does not have to be the email. I would like the server to update
the rates once every day. Can someone help me?
Thanks a bunch for your help.
John
Dan Guzman replied...
As long as the exchange rate data can be provided in a file, it should be
fairly easy to perform this process in a DTS or SSIS package. You can run
it after the file is downloaded. You can also include an FTP process to
automate file delivery and schedule the package in a SQL Agent job.
--
Hope this helps.
Dan Guzman
SQL Server MVP
Web Replication Error When Creating Subscriptions SQL Server Hi guys, I have two servers at different locations (connected over the Internet), and I Internet does not work for me. I have been able to create a publication on server A. I am now trying to create a push subscription from server A to server B. I proceed as follows on server A: • Right click on the publication in SQL Server Management Studio. • Choose “New Subscriptions…â€. • Select the correct publication and click
Execution plan SQL Server I have simple select statement: SELECT d.ID, d.name FROM dbo.table1 t1 INNER to use different execution plan, than it is execution is ok. The question is, why SQL optimizer takes wrong execution plan? There is no missing statistic and all statistics are up common way for deal with such problems? Any instructions? Thank you for your answers, Simon SQL Server Programming Discussions SQL Server 2000 (1) SQL Server 2005 (1) SQL Server 2008 (1) SQL Server (1) Smalldatetime (1) CREATE TABLE (1
Unable to edit data in table in Management Studio 2005 SQL Server I'm having trouble editing data in a table in SSMS 2005, the way one those conditions applying to my table. The system informatiion from SSMS Help, About is Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services Client Tools 2005.090.3042.00 0.50727.3082 Operating System 5.1.2600 How can I get around this error? SQL Server Clients Discussions SQL Server 2005 (1) SQL Server 2008 (1) SQL Server (1) Internet Explorer 7 (1) Windows Update
Applying initial snapshot for merge replication SQL Server Hi, I want to configure a very slow connecting SQL server (coming over the internet) as a subscriber to my merge replication publication. No matter, however not deliver the snapshot. So I want to apply the snapshot manually to the subscribing server. Also I can nly configure the subscriber for a push subscription. How do I go about applying the snapshot manually is my simple question. Thanks SQL Server Replication Discussions ADSZJG.Sainsburys (1 SQL Server 2005 (1) SainsburysADSZJG (1) SQL01.Sainsburys (1) Uniqueidentifier (1) CareACICodes (1) CREATE TABLE (1
Why is use of triggers discouraged? SQL Server I have been working with SQL server for only 6 months and am surprised to notice most articles discourage use of triggers. What is the reason? Thank you, Omid SQL Server Programming Discussions SQL Server 2005 (1) SQL Server 2000 (1) SQL Server (1) Linux (1) History.dbo.Customer (1