Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2007-11-29
7
Medium Priority
?
5,900 Views
Last Modified: 2012-06-27
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
Comment
Question by:xizwyck
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 15

Expert Comment

by:spprivate
ID: 20373943
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
 
LVL 3

Author Comment

by:xizwyck
ID: 20374441
The source file name would be the same.

When you say BulkCopy, do you mean BCP?
0
 
LVL 15

Expert Comment

by:spprivate
ID: 20374733
yes,just look into a post we answered few days back.
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 15

Expert Comment

by:spprivate
ID: 20374754
0
 
LVL 15

Accepted Solution

by:
spprivate earned 1500 total points
ID: 20374809
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
 
LVL 5

Expert Comment

by:MrNetic
ID: 20374919
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
 
LVL 3

Author Comment

by:xizwyck
ID: 20479510
Sorry, been busy. Thanks everyone!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question