Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Export through MS SQL Server

    I am new to the MS SQL Server, is there any command that exports a Table form Microsoft SQL Server 7 to a delemiterd text file?
    Also, how could it be automated? i.e not form the GUI but through the schedule manager

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    You can use bcp or DTS to export a delimited file. With bcp, you need to look up xp_cmdshell in Books OnLine (BOL), and build a bcp string to execute via a scheduled SQLServer Agent job. With DTS (visit www.SQLDTS.com for an opportunity to learn about DTS) you build the DTS package and then schedule the job to run via SQLServer Agent.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you for your help, I'll have a look....
    Thanks again

  4. #4
    Join Date
    Dec 2003
    Location
    Bangalore
    Posts
    28
    Quote Originally Posted by hammbakka
    I am new to the MS SQL Server, is there any command that exports a Table form Microsoft SQL Server 7 to a delemiterd text file?
    Also, how could it be automated? i.e not form the GUI but through the schedule manager

    Thanks
    If you are looking to export to a delemited text file, BCP can do the Job faster than DTS !! u could schedule it as well..

  5. #5
    Join Date
    Oct 2004
    Posts
    25
    You can schedule dts. I usually save dts as stuctured storage files and launch them though the scheduler. dtsrun.

  6. #6
    Join Date
    Dec 2003
    Location
    Bangalore
    Posts
    28
    u r right Ebola!! u can schedule dts as well!! my choice was for performace when the export is to txt files... I prefer BCP for that...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •