I currently have an SSIS package that runs scripts on a database and populates excel templates with the results of the scripts and mails the excel sheets to the recipients.
There are 2 Excel Templates:
REVSTATS_SR runs for each Sales Rep, 3 worksheets are populated with the results of 3 scripts. The Excel sheets are then mailed to the individual reps
REVSTATS_MMG combines the results from the individual reps excel sheets and mails the Excel Sheets to Management.
I need to changes made to the package to:
1. Change 1 of the scripts to add an extra field/column to the results and change the template so that the extra field/column is included.
2. Add another Script/worksheet to the templates so that now 4 scripts will run for each rep.
17 freelancers are bidding on average $183 for this job
Hi!, I'm a SQL server expert! I have developed and several dtsx packages. I can do this task. I have experience in SSIS, SSRS and TSQL. Thanks in advance!
Hi I may deliver you that solution in good price as I'm new to freelancer and I'd like to build a good reputation here. Hope we could work together. Best regards Krzysztof S.
Hi I am expert in SSIS so you can give me this work. I will try to complete as soon as possible. So please communicate with me to start work. Thanks in advance.
Hi! I'm working with SSIS in a daily basis right now, and I became very proficient using this software to solve all kinds of automated data import, migration and report generation.