SSIS Package and email notification send

$10-60 USD

완료함

게시됨

거의 3년 전

$10-60 USD

제출할때 지불됩니다

Need a new SSIS package which will check for list of files (file names will be provided) in a folder on the server then these actions below need to execute in the package. IF any of the listed files exist then NO ACTION needed ELSE Send email notification to users (emails will be provided later) with error message. END IF IF any of the files size<>0 KB then NO ACTION needed ELSE Send email notification to users (emails will be provided later) with error message. END IF More details will be provided if needed. Thanks!

SSIS (SQL Server Integration Services)

Microsoft SQL Server

SMTP

프로젝트 ID: 30629348

프로젝트 정보

3 제안서

원격근무 프로젝트

활동 중 3년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@Truonggiang86

Hello there, to do this first we need to have a table within list of file name MUST HAVE, and we will loop folder to check the existing file, if one missing we will record into one temp table, next for also check in paraller if existing file has size equal to 0 then record too, After that we will generate the task to send the email which file does not exist and which file exist but the size is equal to 0. Waiting for your response if interested. Thank you!!!

$90 USD 2일에

5.0

(9 건의 리뷰)

4.2

3 이 프로젝트에 프리랜서들의 평균 입찰은 $64 USD입니다.

@praveenkarader

It can be done with or without creating the table. SSIS provides you all features to make it dynamic and give future proof. Based on your need we can customise it in the SSIS package. I'm Praveen, I've 10 years of experience into SQL Server and it's components SSIS, SSRS etc., I've delivered much more complex packages than this. I guarantee you to provide best solution. Please click on chat button so that I can understand your need and decide further. Thanks.

$56 USD 1일에

5.0

(2 건의 리뷰)

2.6

@bsreddy576

HI, I can help you create the package to achieve your expectations. Please ping me over chat to discuss more on this further. I am a dedicated MSBI developer holding over 8 Years of rich experience.

$45 USD 1일에