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


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, 100.000 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


Taidot: Tietokantakehitys, Tietokantaohjelmointi, Microsoft SQL Server

Näytä lisää: upload csv statistical data, stored procedure copy data tables write, stored procedure copy data table sql server 2000, stored procedure copy data table, stored procedure copy data sql server, sql server use stored procedure copy data, mssql stored procedure copy data table, sql server stored procedure copy data, sql server stored procedure copy data table, bulk upload csv data sql server cnet, conversion data type sql 2005 stored procedure, stored procedure copy data server server, stored procedure copy data, stored procedure copy data table sql 2005, sql stored procedure copy data

Tietoa työnantajasta:
( 1 arvostelu ) Salzburg, Austria

Projektin tunnus: #14384521

64 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

€155 EUR 3 päivässä
(19 arvostelua)

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) [url removed, login to view] Relevant Skills a Lisää

€250 EUR 5 päivässä
(29 arvostelua)

A proposal has not yet been provided

€250 EUR 7 päivässä
(42 arvostelua)

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

€66 EUR 3 päivässä
(40 arvostelua)

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 Lisää

€277 EUR 10 päivässä
(6 arvostelua)

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 Lisää

€222 EUR 10 päivässä
(4 arvostelua)

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 Lisää

€166 EUR 3 päivässä
(30 arvostelua)

A proposal has not yet been provided

€198 EUR 2 päivässä
(20 arvostelua)

A proposal has not yet been provided

€222 EUR 3 päivässä
(15 arvostelua)

Hi! Got your projet task - I can help you with completeing that with all requirements met. Task will be done with only MSSQL tools, no third-party applications. Relevant Skills and Experience 10+ years experience in M Lisää

€100 EUR 2 päivässä
(1 arvostelu)

Sr. Developer having 7.5+ years experience. Relevant Skills and Experience C# .Net, MVC , PHP, VB .Net, HTML, CSS, Bootstrap, Typescript, Javascript, Jquery, Anguler Js, Anguler 2, Kendo UI, Google API, Mobile Jquery, Lisää

€222 EUR 10 päivässä
(6 arvostelua)
€155 EUR 1 päivässä
(2 arvostelua)

Steps to follow: 01. [url removed, login to view] 02. [url removed, login to view] 03. [url removed, login to view] Now create Job with 2 steps 1st create CSV file 2nd upload on FTP. Please review my profile Relevant Skills Lisää

€84 EUR 1 päivässä
(12 arvostelua)

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 3 päivässä
(5 arvostelua)

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 3 päivässä
(6 arvostelua)

Hi, I'm a DWH/ETL expert from Bulgaria (EU) with 8+ years of experience in that field. I'm proficient in wide variety of data tools: 1. ETL - SSIS, Pentaho Kettle, Oracle Data Integrator (ODI), Informatica Pow Lisää

€250 EUR 5 päivässä
(1 arvostelu)

A proposal has not yet been provided

€80 EUR 2 päivässä
(3 arvostelua)

experoence 10 years in sql server database

€220 EUR 5 päivässä
(4 arvostelua)

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 Lisää

€244 EUR 3 päivässä
(7 arvostelua)

moving content to csv from sql is easy task but need to check for ftp transfer stuff. i could havr started from tommorrow but i am a bit busy with family in weekend. Can start from monday if you are not in hurry....

€166 EUR 5 päivässä
(2 arvostelua)