Re: [mugh-sqlcon] extracting data into tab delimited text files from SQL SERVER Tables in Batch Process
- Hi Raj Sekhar,
Other simple way to do this is using BCP. Check for
the BCP help in BOL. Create a procedure by make use of
BCP and dump the data in to tab delimiter text file.
If you create a procedure, there is a possibility of
passing parameters to dump required data. You can also
schedule this procedure as an agent job.
If you know how to make a BCP command string and
execute with help of XP_CMDSHELL, then you are almost
Let me know if you need ant assistance further.
--- veer wangoo <vwangoo@...> wrote:
> You can use DTS packages for same and Schedule them
> even in the form of Jobs and
> even call them fron VB/ASP code to trigger them...
> Please let us know if you need some help in this..
> Raja Sekhar <rajasekhar@...> wrote:
> Hi All,
> I have following question.
> I need to extract the data into tab delimited text
> files from SQL SERVER Tables in Batch Process.
> Manually we can do using Import/Export Utility. But
> how can we extract the data into tab delimited text
> files from SQL Server in batch process. What scripts
> we need to write and how we can Schedule the Scripts
> for batch processing.
> Thanks In Advance
> Raja Sekhar
> SqlCon is a special interests group run under the
> aegis of MUGH - http://www.mugh.net
> Visit http://www.mugh.net/dnug to join .NET User
> Yahoo! Groups SponsorADVERTISEMENT
> Yahoo! Groups Links
> To visit your group on the web, go to:
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
> VEER JI WANGOO
> SQL freak...Dot Net Charmer
> ALTERNAT EMAIL ID:- veer_w@...
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around