How can I schedule SQL Server Agent to load data from an excel file on a daily basis.
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
Thanks
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial