November 23, 2009 at 11:20 pm
Hi,
How can I write SQL Job for export excel sheet data to sql table,
excel sheet contains CompanyName,Date,NetProfit. SQL Table having CompanyId,date,NetProfit.Here CompanyId is foreignkey
Thanks in Advance
Regards,
Suresh
November 23, 2009 at 11:56 pm
Create an SSIS package to read from the excel sheet and load it into the database. Execute this package using a sql job.
There are lot of other ways as well, take a look at this link.
http://support.microsoft.com/kb/321686
---------------------------------------------------------------------------------
November 24, 2009 at 12:42 pm
Microsoft SQL Server Integration Services is mainly used for ETL type tasks. This is typical of an ETL task. Its a very quick and easy package that can be built and deployed onto your Integration Services server and executed as a job for the specific databases on that server. Don't forget to schedule your SQL job once you've created the job!
You can also perform a manual ETL from a Databases by right-clicking the chosen DB --> tasks --> "Import Data".
Thanks,
S
--
:hehe:
November 24, 2009 at 12:48 pm
What Slick was referring is to use Import/Export Wizard...
That is the easiest and quickest method to export excel files to SQL Server table.
If the task is to be performed frequently, SSIS is the way to go.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply