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?

Improve company productivity with a Business Account.Sign Up

x
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.