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)
64 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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
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....