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 |
|
rwklein1
Starting Member
5 Posts |
 Posted - 2004-12-23 : 19:29:05
|
| 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? Thanks!R Miller |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-12-23 : 20:33:40
|
From EM right click on the DTS package and select Schedule. |
 |
|
|
rwklein1
Starting Member
5 Posts |
Posted - 2004-12-23 : 20:57:33
|
| Thanks for the reply, but how do I create a DTS package ?I've been doing the Export using some wizard that prompts me for all the steps, then spits out a .CSV file (this works well). I just need to schedule this EXPORT to run weekly, I'm familiar with EM, just don't know how to creat a DTS package. Thanks!R Miller |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-12-24 : 03:18:46
|
| You need to use the save option on the Wizard, this will create a DTS package (that you can look at and alter and schedule from Enterprise Manager) and on the same screen you need to select the Schedule DTS package for later execution option and put your settings into there. On the Start menu somewhere you should have an import and export data option which will allow you to create and alter packages.When you are feeling braver you may want to look at BCP in BOLsteveTo alcohol ! The cause of - and solution to - all of life's problems |
|
|
|
rwklein1
Starting Member
5 Posts |
Posted - 2004-12-24 : 03:42:55
|
| Hi Steve, thanks! Real quick... what is BCP? Is "BOL" Books On Line?Can you tell I'm a newbie? :-) Thanks again.R Miller |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-12-24 : 04:01:44
|
| Yes BOL is Books Online. BCP is an alternative to DTS and is preferred by many to DTS. It's explained in BOL. I think at the moment you may find DTS easier.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 - 2004-12-24 : 09:45:11
|
| >> BCP is an alternative to DTS and is preferred by many to DTS.I thought that was just me.==========================================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. |
|
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2004-12-24 : 11:23:54
|
| create a job in enterprise manager, choose as an command line, and run bcp command in it, set run time and that's it. Read the help file for more. |
|
|
|
|
|
|
|
|
Can I run a Job to do an Export of one table?