En cours

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


Compétences : .NET, Microsoft, Serveur SQL Microsoft, Powershell, VB.NET

en voir plus : 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

Concernant l'employeur :
( 11 commentaires ) Ireland

Nº du projet : #16943306

Décerné à:


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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(1 Évaluation)

13 freelance font une offre moyenne de $207 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(25 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(11 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(3 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(12 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(9 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(2 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)