Write to txt file

I am very new to SSIS. What I want to do is to query, then write each record to text files.
Sample : record 1, account # 123, create a file called 123.txt and then write the rest of the data in this format

customername | Jim Thompson
address           | 123 S. La Cruz
city                  | San Francisco, ca 95555

etc
 
         Record # 2   account # 345  create text file called  345.txt and write the rest like above.
VBdotnet2005Asked:
Who is Participating?
 
k_murli_krishnaConnect With a Mentor Commented:
At command line or shell prompt, use pipe or redirection operator > to create a file and >> to append to existing one. In SSIS, try these references:

SSIS: Exporting data to a text file using a package
http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/
SSIS: Flat File Destination - How To Append Data?
http://www.eggheadcafe.com/software/aspnet/33177109/ssis-flat-file-destinati.aspx
SSIS: Adding footer row to a flat file already containing data
http://database.ittoolbox.com/groups/technical-functional/sql-server-l/ssis-adding-footer-row-to-a-flat-file-already-containing-data-3178205#M3178257
0
 
Reza RadConsultant, TrainerCommented:

you need to create new SSIS project

add a DATA FLOW TASk
add a oledb data source and connect it to your database(for example sql serever datebase)
add a Flat File destination for your text file
set mappings

and then everything will be fine
you could set delimiter type, set type of text file: delimiter, fixed width or ragged right


0
 
Reza RadConsultant, TrainerCommented:
let me know where in the above steps you have problem exactly and I explain more in details.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
VBdotnet2005Author Commented:
reza_rad
Your steps above write to a fle? I want it write each record(above format)on each text file. Your help is greatly appreciated.
0
 
Reza RadConsultant, TrainerCommented:
no actually,
the steps above will write each record in one line of text file.
if you want to change the way of writing to text file as above(which is familiar to me from your previous questions), you should use Script Component Transformation between source and destination.

if you need more detailed help,provide a sample table data, and also a sample requested result with more than one row data.
0
 
Reza RadConsultant, TrainerCommented:
Did you got the answer to your question ??!!!!!!!!!!!!
I think you can not do this without script component transformation. you should read this format in script and make your output rows in code.
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.

All Courses

From novice to tech pro — start learning today.