Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 26
  • Last Modified:

Help in automating monthly data dump

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
ac_davis2002
Asked:
ac_davis2002
  • 2
  • 2
1 Solution
 
Anthony PerkinsCommented:
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
 
ac_davis2002Author Commented:
Yep i can i have SSIS, can i automate using that do you think?
0
 
Anthony PerkinsCommented:
Absolutely.  Well, provided that the Excel data is well-formatted.  Typically you are better off importing from text files.
0
 
ac_davis2002Author Commented:
Excellent thank you!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now