I gang

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

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]")


[login to view URL] = False

'Set Wb = [login to view URL] strExcel

With objworkbook


.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


Evner: .NET, Microsoft, Microsoft SQL Server, Powershell, VB.NET

Se mere: project using ftp task ssis package, build solar system using maya, ssis package ftp, ssis package creator, build xml file using crystal, ssis package extract sql data text file, build online exam using asp, using wordpress news script, using alibaba clone script tutorial, build interactive calendar using visual basic, upload multiple files using php java script, websites using vacation rental script, using sed bash script, build job site using cakephp, system requirements build inventory system using php mysql, check system health using unix shell script, build dealer locator using coldfusion, build dating website using gwt, build joomla template using photoshop, ftp task ssis package

Om arbejdsgiveren:
( 11 bedømmelser ) Ireland

Projekt ID: #16943306

Tildelt til:


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 Flere

$200 USD in 3 dage
(1 bedømmelse)

13 freelancere byder i gennemsnit $207 på dette job


Hello, I am Microsoft Certified developer with more than 8 years of IT industry experience and worked on different kind of projects from different geography. I have strong experience in developing Software applic Flere

$250 USD in 3 dage
(25 bedømmelser)

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 subscri Flere

$35 USD på 1 dag
(11 bedømmelser)

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 w Flere

$223 USD in 2 dage
(16 bedømmelser)
$250 USD in 5 dage
(3 bedømmelser)

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, fo Flere

$155 USD in 7 dage
(12 bedømmelser)

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 ment Flere

$300 USD in 4 dage
(9 bedømmelser)

A proposal has not yet been provided

$222 USD in 3 dage
(7 bedømmelser)

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 dage
(5 bedømmelser)

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 en Flere

$277 USD in 5 dage
(2 bedømmelser)

A proposal has not yet been provided

$200 USD in 3 dage
(0 bedømmelser)

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 int Flere

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

A proposal has not yet been provided

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