SolvedPrivate

Help in automating monthly data dump

Posted on 2013-01-22
4
19 Views
Last Modified: 2016-02-10
Hi

I have a monthly task to produce a data dump

I have to do the following steps

Truncate a data table

import fresh data from excel

run a select statment to select data from the data tables includimg the data in the table previously refreshed into a sql report.

import the data from the sql report into excel.


I would like to know the best way to automate the above can anyone help please?
0
Comment
Question by:ac_davis2002
  • 2
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 38805533
Can you use SSIS and a SQL Server Agent job to automate it?  In other words, is you Edition of SQL Server something better than SQL Server Express?
0
 

Author Comment

by:ac_davis2002
ID: 38807017
Yep i can i have SSIS, can i automate using that do you think?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38807376
Absolutely.  Well, provided that the Excel data is well-formatted.  Typically you are better off importing from text files.
0
 

Author Closing Comment

by:ac_davis2002
ID: 38810688
Excellent thank you!
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now