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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-26 : 06:58:44
|
| NORIE writes "Hi all,I would like to have your opinion and know how of using sql server for the problem I have in hand. I would have several xls with lots of data. Therefore I have designed a db to have this data.Manually I know how to import data using sql server. I wanted to automate the process of loading data into the tables from xls. someone told me that I have to create a package to do this.I really dont know the procedures for creating a package and scheduling them. If anyone lets me know this I would be really very thankful.Cheers,L N" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-26 : 13:00:10
|
| You need to create a DTS Package. You can do this in Enterprise Manager under Data Transformation Services. Once you've designed it, you can right click on it to schedule it. You could also schedule it using dtsrun.exe in SQL Agent.Tara |
 |
|
|
|
|
|
SCHEDULING JOBS IN SQL SERVER