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 recuiterMember since Nov 11, 2022 Melanie Nathan
from Metropolitana de Santiago, Chile