Import Excel File using SSMS

I use SQ Server 2008 with SSMS. So in SSMS (Management Studio) there is SQL Server Agent that is used to run jobs. My question is: is there way to pull in data from Excel using SQL Server Agent?
SeTechAsked:
Who is Participating?
 
Jerry MillerConnect With a Mentor Commented:
If you right click on the job in question, choose properties and look at the job history, it  gives you the log file viewer where you can see a history for that job.
0
 
Jerry MillerCommented:
You can do it through an SSIS package. Here is tutorial with step by step instructions.

http://www.mssqltips.com/sqlservertutorial/207/creating-a-simple-ssis-package/
0
 
Jerry MillerCommented:
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
SeTechAuthor Commented:
Thanks, I have a SSIS package that produces the results I want. My problem came into being when I upgraded to Windows 7. In the past with XP I was able to schudle my SSIS package, however now the Scheduler will not "fire" off the SSIS package in question... Therefore I thought I would just go right to the server.
0
 
SeTechAuthor Commented:
Jmiller1979: I should have been more specific. I am well versed with the Import Wizard, what I want to do is Schedule the Import on a daily basis.
0
 
Jerry MillerCommented:
That is a completely different question than the one you asked. The SQL Server agent is not launching scheduled jobs or are they failing?
0
 
Jerry MillerCommented:
If you have a SSIS package that does what you need, you can upload it to the SQL server and schedule it using the SQL Server Agent.
0
 
SeTechAuthor Commented:
It is not launching.
0
 
SeTechAuthor Commented:
jmiller: I will check that out and see if I can solve my problem, if not "I Shall Return"
Thanks Much
0
All Courses

From novice to tech pro — start learning today.