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 - 2005-01-05 : 08:15:15
|
| Wendy writes "Totally new to SQL*Server. I was just asked to export rows from a Table using the DTS Import/Export Wizard (to a comma delimited flat-file). It was very simple, but I need to Schedule a Job to do this export once a week. Just learned how to schedule a Job to EXEC a stored procedure. How do I schedule a Job to start an Export of one table ?" |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-01-05 : 11:01:32
|
| It's one of the options at the end of the DTS Wizard (you have to save the DTS package otherwise there is nothing to schedule)SteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-05 : 11:52:02
|
| Even simpler to do it via bcp and schedule the command.More flexible to put the command in a stored proc and schedule that.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Question about exporting data using DTS Wizard