February 2, 2009 at 4:17 am
Hi All,
I have various .xls files that are filled with wmi output for servers. I want to import these files into sql tables. I've created the sql tables in my db that have the exact same columns as contained in my .xls files. Each .xls file has a corresponding table:
E.G - servers.xls = dbo.servers
I can import them manually by clicking on my db and importing them to the specified tables, however I want to automate this job. Does anyone know of a way to do this?
Thanks.
February 2, 2009 at 6:17 am
...SSIS is the way to go, personally I feel it's easy to understand and has a lot of useful features that can by dynamically changed. However, you can also do this using OPENROWSET & Linked Servers as well.
--Ramesh
February 2, 2009 at 6:41 am
Thanks for the response. I can't see SSIS anywhere on my enterprise edition of sql2005 - where is it located?
Cheers
February 2, 2009 at 7:00 am
Though the task is quite easy to do, but personally I think you have to start reading books, articles & spend some more time doing practicals.
You build packages in SQL Server Integration Services (SSIS) by using Business Intelligence Development Studio (BIDS) or Visual Studio.
--Ramesh
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply