• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5916
  • Last Modified:

MS SQL Server 2000/2005 - Export data to text file (ASCII) in binary format?

I thought I read this some where but is it possible to routinely export data from SQL Server into a text file (ASCII) in a binary format? I have the pleasure of creating an interface to deliever data to a mainframe system using COBOL (a middleware service converts the file I'm sending).
0
xizwyck
Asked:
xizwyck
  • 4
  • 2
1 Solution
 
spprivateCommented:
You can hae SQL Jobs and DTS package or BulkCopy to do this trick.Is the source file name going to be the same althrough?
0
 
xizwyckAuthor Commented:
The source file name would be the same.

When you say BulkCopy, do you mean BCP?
0
 
spprivateCommented:
yes,just look into a post we answered few days back.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
spprivateCommented:
Oh mY bad
I misread the question.You wanted to exprt data rather than import it to SQL.Hmm
well
You can use SQL Import Export wizard and create the destination as flat file source .Now create this as an SSIS package(DTS in 2000) and schedule it.
0
 
MrNeticCommented:
You can create a SSIS package that for example will export the data to a txt file, then export the file using ftp tp the mainframe and in the end receive a e-mail report.
You can do this just by developing a SSIS package.

Hope this helps.
0
 
xizwyckAuthor Commented:
Sorry, been busy. Thanks everyone!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now