Build SSIS Package using VB 2017 SSDT ( VB Script included below)

$30-250 USD

In Progress

Posted

about 6 years ago

$30-250 USD

Paid on delivery

I wish to refresh an excel sheet and email it to a user. The excel file has a connection to a SQL Database so the file must be refreshed and then emailed out to a user I have previously done this using some Vb script in a BAT file and triggered this using a Windows scheduled task, but this is a bit legacy now and I want to implement a more professional method. Below the VB script I previously used: 'Dim objExcel , wb Set objExcel = CreateObject("[login to view URL]") set objworkbook = [login to view URL]("c:\ReportDEV\[login to view URL]") objExcel.Visible=False [login to view URL] = False 'Set Wb = [login to view URL] strExcel With objworkbook .RefreshAll .Close True End With [login to view URL] Some infrastructure and software details OS= Windows Server 201 R2 SQL Version= Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) Mar 19 2015 12:32:14 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) Visual Studio = MS SQL Server Data tools for Visual Studio 2017 ( SSDT) MS Office 2016 is also installed on the server I've done a bit or research and I need this re-written for VS 2017 SSDT and the rest of the package written so that the updated excel file is emailed out using SMTP I'm very open to better ways to do this, but please note the Excel file contains a lot of formatting so simply extracting the directly from the DB in SSDT is not an option. I can't supply the file as it includes sensitive information but if you can write and supply the package and demonstrate that it works given the above scenario then that will suffice Thanks

Project ID: 16943306

About the project

13 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@dvcontact

Hi, Reading your project description about refreshing an Excel sheet and emailing it to a user makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you have entrusted this task. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?

$200 USD in 3 days

5.0

(1 review)

3.2

13 freelancers are bidding on average $207 USD for this job

@marasinghe82

Dear Sir, This can be implemented using SSIS package on fully automated scheduled job or sine you have MSSQL 2008 R2 you have access to the SSRS we can build report and published to reports server and configure subscription to required recipients even with data driven subscriptions you can have browser base report server console. I sure you should be happy 100% :-) I'm expert developer on all this technology stack. Please assign this task to me I really reconnect freelance portal and I need only good review Best Regards, Jinesh

$35 USD in 1 day

4.8

(11 reviews)

4.7

@vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 5 months experience in SQL and 5 years and 7 months experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe jikenjd

$223 USD in 2 days

5.0

(16 reviews)

3.9

@huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$155 USD in 7 days

4.6

(12 reviews)

3.4

@ianoc

Good day! I would be glad to help you with this job of refreshing your Excel sheet and emailing it using an SMPT server. I have an enormous amount of experience working with both Excel and Visual studio (not to mention SQL Server Data Tools) and I can come up with the best way to get this done for you with minimal load on your CPU. My profile in brief: * Over 15 years of industry experience in IT and software desgining/programming * Close to 10 years of freelancing experience at freelancer.com (with 5 star ratings for previous work) * 100% on-time, on-budget completion rate Your requirement is quite clear to me but please let me konw why you want to use SSDT? ( I don't see a need to use this to do achieve what is required). Please let me know if you have any other particular needs than mentioned in the project description so I could understand this better. Anyway, if your requirement is just to refresh the Excel sheet with the data from SQL database/table, and email the sheet to using SMPT, i woul be more than glad to get it done using just Visual studio 2017 VB.NET. What I have in mind is an executable that would let you choose the excel file at the start (or I could hard code it), then it would run in the background/system tray) and refresh the sheet and email it after a given period of time and continue to do so until the program is closed). Please let me know what you think. I look forward to hearing from you and getting this job done for you.

$300 USD in 4 days

5.0

(9 reviews)

3.2

@bnrajumnc

A proposal has not yet been provided

$222 USD in 3 days

5.0

(7 reviews)

3.1

@sreenivas2903

Hi as you said you have lot of formating in excel please provide with dummy info so taht i have a clarity about the transformations in ssis

$222 USD in 3 days

5.0

(5 reviews)

2.8

@alioke29

hi, i have excel experience work on this.....please award me good project experience 8 years in web and desktop application my skill : asp.net mvc c# javascript jquery bootstrap html5 web service api gateway linq entity framework etc.

$277 USD in 5 days

4.0

(2 reviews)

2.0

@Setrambhardaj

A proposal has not yet been provided

$200 USD in 3 days

0.0

(0 reviews)

0.0

@maneeshkrverma

I have 10 years exp in designing the etl process for loading data in data warehouse. I am new freelancer and looking for challenging opportunity. I will use data flow task in ssdt to pull data from source and load into Excel. after that will apply formatting in script task in ssdt with c# code. and then smtp task in ssdt will be used to send the email. let me know when can we further discuss. I need to know if this file is single sheet or multiple sheet. it will be helpful if you share the Excel with sample data with formatting.

$200 USD in 5 days