Find Jobs
Hire Freelancers

SSIS: Setup a package with Logging to SQL Server Database and Configurations Written to Database

$15-25 USD / hour

Dokončeno
Zveřejněno skoro před 6 roky

$15-25 USD / hour

This project is to create a SSIS package that has logging configured. The logging configuration should set setup to write events to a SQL Server database. The standard package events to the log. In addition to the preconfigured events, will need to add custom log entries that occur during processing of the package. For example, a record count of records processed would need to be written to the log. In addition to setting up logging, the package needs to be configured to have the configurations like connections strings, variables, etc. stored in a SQL Server database table. These configurations will need to be able to be modified in the database table and effect the package. Last item will be to setup email alerts that send email alerts when package completes successfully or when package fails. When package fails, the log of events should be included in the body of the email. The subject should read, "SSIS {Package Name}" Failed to complete! Please review the log details below". When a package succeeds, the log of events along with times taken to process each step should be included in the body of the email. Also, custom log entries should also be included. For example "Records Process: 120,112". This package will be the basis for an ETL that will update a data mart daily. This complete package will load data from flat files daily, transform that data and update the data mart tables with new data. If this initial project works out, the freelancer awarded will have the opportunity to work on other parts of this project over the next 6 to 8 weeks. Freelancer needs to have demonstrated experience developing SSIS packages that will be processing high volumes of data each day. Experience with SSRS and SSAS will be a plus.
IČ projektu: 17347894

O projektu

4 nabídky
Vzdálený projekt
Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Hello i have good experience with SSIS , how many hours do you need /week ? There are some examples of packages in my profile page if you like to take a look . Thanks
$33 USD v 40 dnech
5,0 (65 recenze)
7,1
7,1
4 freelanceři nabízejí v průměru $24 USD/hodinu za tuto práci
Avatar uživatele
Hi there..... Warm Greetings We came along with your request for SSIS: Setup a package with Logging to SQL Server Database and Configurations Written to Database and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Microsoft SQL Server, SQL, SSIS (SQL Server Integration Services) We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$25 USD v 40 dnech
5,0 (7 recenze)
5,0
5,0
Avatar uživatele
have been working with Sql for last 13 yrs...have worked with SSIS long time back to be honest. searching for an opportunity work again in SSIS. hope to hear back from you.
$16 USD v 30 dnech
5,0 (3 recenze)
3,1
3,1

O klientovi

Pochází z UNITED STATES
Royal Palm Beach, United States
5,0
5
Ověřená platební metoda
Členem od zář 28, 2017

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.