Ssis and scripts for excel and geocoding

Create generic packages so that data/tables can be used by anyone.

SSIS Package #1:
Loop through options for each group id , group name in stored Proc or table
Get data from the loop
populate template xlsx file
Reformat it (template includes data tab , and two pivots that should be auto populated).
Save with specific names based on group id , group name from above plus date
go to next groupid , groupname in the list until done.
Create job script to execute ssis and create email from job as HTML.
notify users that the file is available now in the directory specified.


SSIS Package #2:

Have a loop similar to #1
I will share a file with shortlisted candidates export those file
open source free tool to create xlsx files.


During loop:
get data, create initial page with raw data, second sheet with pivot chart, third sheet with graphs.
save with specific name as above with date.
SIS Package #3

Create Google and Bing Geolocation API that will map Customer database with unique id, address, city, state, zip USA only.
Which will output all of the input table plus longitude and latitude and status if nothing is found.


SQL Stored Procedure :

Similar to #3 but it will take input address and list of other addresses from database and provide output of distance in Miles between those addresses.


About the recuiter
Member since Mar 14, 2020
Narinder Singh
from Gavleborg, Sweden

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions