Đã Hủy

MS SQL: Execute a select statement, dump the data to csv and upload to an ftp DAILY via stored procedure

Hello,

since I am new to SQL and programming, I need help with a little task from db automation. I provide you with an SELECT statement fetching data from 3 tables within one database (40 columns, [url removed, login to view] rows are the results of this query).

I need this SELECT Statement to be run every night at 02:00 am automatically. The data need to be dumped into an CSV file. The Name of the CSV must be ‘Newsletter_Batch’ and the current date.

This CSV file then needs to be uploaded to an FTP Server. Estimated file size is 30mb. The original file needs to be stored in a local folder.

For the task use a stored procedure and the tools from within MS SQL Server. For the task use the Jobs from the SQL Server Agent. No 3rd party applications.

Please make sure that additional columns can be added to the select statement easily and the scheduled time can be manipulated via the SQL Server Agent interface.

Please deliver the code and a detailed step by step explanation I can follow to deploy the code.

Version: Microsoft SQL Server 2014 (SP1-GDR) (KB3194720) - 12.0.4232.0 (X64)

Best regards

Ray

Kỹ năng: Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu, Microsoft SQL Server

Xem thêm: upload csv statistical data, stored procedure copy data

Về Bên Thuê:
( 0 nhận xét ) Salzburg, Austria

Mã Dự Án: #14384521

69 freelancer đang chào giá trung bình €158 cho công việc này

papon13

A proposal has not yet been provided

€250 EUR trong 7 ngày
(34 Đánh Giá)
5.8
mahmoudgamal008

I have more than 5 years of professional and practical experience in SQL and sql server. I have more than 1800 answers in Stackoverflow(Q&A Site) http://stackoverflow.com/users/722783/mahmoud-gamal Relevant Skills a Thêm

€250 EUR trong 5 ngày
(29 Đánh Giá)
5.4
fanninson45

I am an experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Relevant Skills and Experience RECENTLY COMPLETED PROJ Thêm

€155 EUR trong 3 ngày
(15 Đánh Giá)
5.5
paskal77

Hi, I propose two options: Develop a windows service or an ETL, both options should work well for you. Relevant Skills and Experience C#, VB.net, Windows Services, Sql Server Proposed Milestones €66 EUR - Full Delive Thêm

€66 EUR trong 3 ngày
(34 Đánh Giá)
4.9
point5nyble

I have excellent database programming skills which is required to complete this project . Please discuss with me project details will ensure best & satisfied delivery. Relevant Skills and Experience • Expert in SQL Se Thêm

€166 EUR trong 3 ngày
(28 Đánh Giá)
4.9
jagdishbhatt38

A proposal has not yet been provided

€198 EUR trong 2 ngày
(18 Đánh Giá)
4.5
Splaszczyk

Hi. I'm from same time zone ( Poland) and i work as SENIOR SQL Server DBA so you know what you pay for. I propose you for this kind task preparing INTEGRATION SERVICES PACKAGE ( i will do it ) - that will execute th Thêm

€222 EUR trong 10 ngày
(2 Đánh Giá)
4.2
IMExpertEngineer

needs to get data from tables and save in csv file and then upload to ftp Relevant Skills and Experience i am expert in sql server Proposed Milestones €277 EUR - as needed Hi, I can do this task but please come onli Thêm

€277 EUR trong 10 ngày
(2 Đánh Giá)
4.1
johnosullivan

A proposal has not yet been provided

€222 EUR trong 3 ngày
(15 Đánh Giá)
4.2
kashivw

I am a veteran (25+ years IT, 15+ database) developer with specific expertise in SQL Server (4.5 thru 16) and Oracle (v6 thru 12c). I have done many such tasks before and am keen to work on this. Relevant Skills and E Thêm

€50 EUR trong 3 ngày
(3 Đánh Giá)
3.5
€155 EUR trong 1 ngày
(2 Đánh Giá)
3.7
vw7590795vw

Steps to follow: 01. USP_GET_NewsLetter_Data.sql 02. USP_ExportToCSV.sql 03. USP_PUT_FILE_ON_FTP.sql Now create Job with 2 steps 1st create CSV file 2nd upload on FTP. Please review my profile Relevant Skills Thêm

€84 EUR trong 1 ngày
(9 Đánh Giá)
3.1
frankoke16

I am a full time programmer. I just wanted to have another job to gain more skills, learn from others and help others to solve their problems. In my full time job, i use .Net framework integrated with SQL, SSRS, MySql, Thêm

€150 EUR trong 3 ngày
(7 Đánh Giá)
3.1
gkalish

I am ready to do start the work. Relevant Skills and Experience Having 10 + years experience in SQL Server and willing to start the work immediately. Proposed Milestones €277 EUR - mile stone 1

€277 EUR trong 3 ngày
(4 Đánh Giá)
3.2
pramsweety

Dear, Thank you for posting a job on my favorite technology i.e., Microsoft SQL Server. I have been working with Microsoft SQL server for the past 5 years in ERP, Big Data and Data warehousing environment. I have b Thêm

€244 EUR trong 3 ngày
(7 Đánh Giá)
3.2
axiomswb

we have expertise in SQL,MySQL,php, DBA, Data processing. Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience SQL,MySQL,php, DBA Proposed Milestones €100 EUR - whole

€100 EUR trong 3 ngày
(5 Đánh Giá)
2.9
mmpatel009

A proposal has not yet been provided

€80 EUR trong 2 ngày
(3 Đánh Giá)
3.1
HDDevelopment

experoence 10 years in sql server database

€220 EUR trong 5 ngày
(4 Đánh Giá)
3.0
joemarecaro

im a solutions developer and this kind of task is included in my regular task. i can help you immediately if you hire me. i can give youbstep by step instructions also on doing this so you can work on your own in the f Thêm

€220 EUR trong 2 ngày
(2 Đánh Giá)
2.9
kkdinesh0270

I have five years of experience in sql development. I have already worked on similar projects. I can complete your project on time. Please award me the project.

€250 EUR trong 3 ngày
(2 Đánh Giá)
2.4