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 |
|
AsimKhaliq
Yak Posting Veteran
94 Posts |
 Posted - 2003-12-17 : 13:02:13
|
| HiI want to export my table data from Sqlserver to excel sheet. what I am doing is iam creating a temptable using my logic from application. Now what i want is to export my data to excel automatically means as the data is added in temp table my dts will run and export the data.I dont have any idea about DTS scripts, packages and auto rum. PLz help me.Thnks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-17 : 13:05:12
|
| AsimKhaliq, use the export data wizard to do what you are trying to do. Then save the package and then go to the DTS designer to see what it is doing. This is an easy way to learn DTS. You also should pick up a book about DTS as it can get pretty advanced. But to do what you are trying to do just use the wizard until you get more familiar with the product.Tara |
 |
|
|
AsimKhaliq
Yak Posting Veteran
94 Posts |
Posted - 2003-12-17 : 13:11:37
|
| Thanks TARA,yes I saw that will explore as much as i can. but what about auto run means run immidiatlly after completion of task(adding record in table).is this thing is cover in DTs or do i have to look some other thing.Thanks in Advance |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-17 : 13:13:56
|
| The run immediately is just for the wizard. To run a DTS package, you can right click on it and click execute, you could also schedule it using the DTS scheduling wizard or you could programmatically call it using DTSrun.exe.Tara |
|
|
|
|
|
|
Export from SQL Server to Excel Using DTS