Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Pavithra subbareddy
Starting Member
1 Post |
Posted - 2014-07-15 : 08:42:09
|
Hi Friends,I wanna to import excel from local to DB table.Excel will be in one server and DB will in another server.this import should be schduled.How to achieve this.My friend suggest to use SSIS.how to use SSIS for this. |
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-07-15 : 09:42:11
|
Assuming a basic knowledge of SSIS:1. Add an Excel Source datasource to your dataflow2. connect it to an OLE DB destination 3. run itIf you don't know SSIS, you can use the wizard in SSMS (Right-click on the target database, select Tasks... then Import Data) |
|
|
|
|
|