Forum Discussion

wchung's avatar
wchung
Frequent Visitor
9 years ago

Automate Daily Snapshot and Trend Graphics

Hi,   I'm building an investment dashboard that combines stock inventory (excel) with Yahoo finance stock price (web) to calculate the net market value of each day. This is refreshed daily after th...
Need Help
Baskar's avatar
Baskar
Resident Rockstar
9 years ago

My suggestion is please go with SSIS 

 

create one package and store data in SQL Table on daily or houtly basic .

 

 

That will help u 

wchung's avatar
wchung
Frequent Visitor
9 years ago

I see, I have no knowledge in SSIS but I'll look into it!

 

Thanks for the comments!

  • Baskar's avatar
    Baskar
    Resident Rockstar
    9 years ago

    welcome dude