I gang

Make changes to an SSIS Package (.dtsx) which runs scripts to populate Excel templates and mails results to recipients

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.

Færdigheder: Excel, SQL

Se mere: ssis populate excel template, changes ssis package, ssis template package, ssis template, ssis package template, SSIS SQL, Sql ssis, mails, i need sales reps, i need a sales rep, excel templates, runs, excel sales management, excel sales worksheet, excel template database, script excel sql, excel populate worksheet worksheet, database templates excel, database excel template, excel worksheet template, excel template sales, database management excel, excel sales sheets, database template excel, recipients

Om arbejdsgiveren:
( 11 bedømmelser ) Ireland

Projekt-ID: #5990377

Tildelt til:

hcy0212

Hi Brendan, I am ready to start, please send me the SSIS files, and sample of the output files. Thanks, John

$70 USD in 3 dage
(5 bedømmelser)
3.4

17 freelancere byder i gennemsnit $183 for dette job

marasinghe82

Dear Sir, Please assign this task for me I'll do it with in one hour time. Further if you have SSRS installation we can do nicely formatted ssrs report and subscribe to the users with exce /pdf attachment on schedul Mere

$35 USD in 3 dage
(60 bedømmelser)
5.5
weonlydo

Hi, This looks like a straightforward task. I come with plenty of experience in SQL/SSIS and great feedback on this site as well as proven calibre - I was Expert of the Year 2010 at Experts Exchange ([url removed, login to view] Mere

$166 USD in 3 dage
(25 bedømmelser)
5.2
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server BI , i have more than 8 years in BI projects around a variety of tools and environments. My las Mere

$526 USD in 6 dage
(13 bedømmelser)
5.0
AndroidAll

Dear sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. If you want, I can develop a demo within a short time. Regards. PS. In order to show my ability, I c Mere

$200 USD in 3 dage
(8 bedømmelser)
4.0
vhrios

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!

$166 USD in 3 dage
(5 bedømmelser)
3.9
dogradiwakar

A proposal has not yet been provided

$244 USD in 3 dage
(3 bedømmelser)
3.9
varaprasadanga

I have a vast experience in related to software development Over 6 years of experience in IT industry having strong skills in ASP.Net, C#.Net, LINQ, SQL Server and Win [url removed, login to view] process, DTS, SSRS,SSIS,ASP.Net, C#. Mere

$222 USD in 5 dage
(1 bedømmelse)
2.8
lucasroy7

I have enough experience with SQL Server Data Bases (SSRS - SSIS). I design relational databases models and develop queries with T-SQL. Please check my Linkedin profile: [url removed, login to view] Mere

$200 USD in 5 dage
(3 bedømmelser)
2.1
jwbart10

A proposal has not yet been provided

$155 USD in 3 dage
(1 bedømmelse)
1.8
DataSprints

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.

$66 USD in 3 dage
(1 bedømmelse)
1.6
singhranvijay

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.

$155 USD in 3 dage
(0 bedømmelser)
0.0
vanpham

A proposal has not yet been provided

$222 USD in 3 dage
(0 bedømmelser)
0.0
msaqibqureshi

I have more than 7 year work experience in SQL Server using the components SSIS, SSAS etc. Good chance if awarded to me

$244 USD in 2 dage
(0 bedømmelser)
0.0
pedrosaisse

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.

$200 USD in 5 dage
(0 bedømmelser)
0.0
milos411

Hi, I have more than 7 years of experience with SQL Server, especially with SSIS. The change you need is easy and I can do it in few hours. I'm trying to start my Freelance career so I'm placing a low bid. Please gi Mere

$77 USD på 1 dag
(0 bedømmelser)
0.0
neeeraj3110

A proposal has not yet been provided

$170 USD in 3 dage
(0 bedømmelser)
0.0