December 7, 2009 at 2:34 pm
Hello experts,
I’ve a task to accomplish which is totally new for me. I’ve 3 tables which are holding the data that I need. Now I’ve been asked to produce 3 text files which will hold this data. Can anybody point me in the right direction from where I should start and how I can accomplish it?
Many thanks in advance
December 7, 2009 at 2:37 pm
Is this something you're doing just this once, or something that will need to be set up for repetition?
If just once, then right-click the database name in Management Studio, go to Tasks, Export Data, and go through the wizard that launches.
If it'll need to be done more regularly, then you have some options depending on the specifics of what you want to do. BCP will probably do what you need, but it might require SSIS if it's complex enough.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 7, 2009 at 2:48 pm
SSCrazy Eights for you input. Yes I’ll need to perform this procedure at the end of every month. Move data to text files and purge data from database. As you’ve mention SSIS will be the best choice. Correct?
December 7, 2009 at 3:45 pm
Yes, SSIS is the best way for this. You can schedule the package to fire off when needed, or fire it off manually at anytime.
You can perform every step needed. If you want to keep a certain number of files for historical reasons, you can create a directory for each day.
Andrew SQLDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply