Three files were uploaded in order to do this question. The excel file shows the formular tabs on the first hand in gray while the blue colors shows hand filled information. Fill in the gray side, the left side of the file correct the formular errors in columns – (B,C,J,P,T2,V2,W2,AC), Then on the right hand side in blue color, fill in information’s in columns – ( AO,AP,AQ,AR,AS,AX,CL,CO, CQ,CR- change supervisor numbers and name, CS).
Make sure all the formulars are data are filled in, where you see #value or #n/a. the data needs correction. Any field blank, leave it blank. After you do that, I need this data to be automated.
I uploaded the queries for this data. Look and the queries and look at the excel data. Use all the information I uploaded and provided to automate this data. You can make up you own data and excel file but let it look like the files I uploaded. SHOW STEPS ON HOW TO AUTOMATE THESE DATA USING SSIS PACKAGE AND UPLOAD THE SSIS VISIO PACKAGE, SO I CAN VIEW HOW YOU MAPPED THE COLUMNS IN VISIO AND HOW YOU JOINED THE TWO QUERIES.