Đang Thực Hiện

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

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

Kĩ năng: .NET, Microsoft, Microsoft SQL Server, Powershell, VB.NET

Xem nhiều hơn: 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, build sample website using dotnetnuke

Về Bên Thuê:
( 11 nhận xét ) Ireland

ID dự án: #16943306

Được trao cho:

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 Thêm

$200 USD trong 3 ngày
(1 Nhận xét)
3.2

13 freelancer đang chào giá trung bình $207 cho công việc này

itpathsolutions

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 Thêm

$250 USD trong 3 ngày
(25 Nhận xét)
6.0
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 subscri Thêm

$35 USD trong 1 ngày
(11 Nhận xét)
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 w Thêm

$223 USD trong 2 ngày
(16 Nhận xét)
3.9
$250 USD trong 5 ngày
(3 Nhận xét)
3.3
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, fo Thêm

$155 USD trong 7 ngày
(12 Nhận xét)
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 ment Thêm

$300 USD trong 4 ngày
(9 Nhận xét)
3.2
bnrajumnc

A proposal has not yet been provided

$222 USD trong 3 ngày
(7 Nhận xét)
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 trong 3 ngày
(5 Nhận xét)
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 en Thêm

$277 USD trong 5 ngày
(2 Nhận xét)
2.0
Setrambhardaj

A proposal has not yet been provided

$200 USD trong 3 ngày
(0 Nhận xét)
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 int Thêm

$200 USD trong 5 ngày
(0 Nhận xét)
0.0
soundarmit

A proposal has not yet been provided

$155 USD trong 3 ngày
(0 Nhận xét)
0.0