How can I schedule SQL Server Agent to load data from an excel file on a daily basis.

SeTech
SeTech used Ask the Experts™
on
How can I set up a SQL Server Agent Job to connect to an excel file and bring the data into a table in SQL. So for example if I have an excel spread sheet with two columns Salesman and Items and I want to get that data into an SQL 2008 database in table Sales. I want to schedule it on a daily basis. I could use the import task, but would not want to do that manually each day.
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
You need to create a SSIS package first then use that one in a scheduled job - just select the "Type" under the step name as SQL Server SSIS package.

For instance you can create the package by starting the Import Wizard just as you said above " I could use the import task, but would not want to do that manually each day." then save it (as a file for instance or inside that SQL Server) so you could use it in a SQL scheduled Job.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial