MS SQL Server - data export to flat file

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

data export to flat file

jchampion728

2006-12-06, 7:12 pm

Hi, I hope you can help, and thank you.
SQL 2000. I need to generate a flat file export from a single table. I need
a line feed between select fields. I've tried using bcp and Bulk Insert with
a format file, but I've never used either, and I must be missing a critical
step somewhere.

The flat file format for a single record would be similar to the following:

Field1, Field2, Field3, Field4, Field5, Image Path1
Image Path2
Image Path3

I appreciate any assistance you can provide. Thanks!

Hate_orphaned_users

2006-12-06, 7:12 pm

Did you try the DTS (data transfomation service)tool in SQL Server 2000?
Easy to use for transforming data to export files.

http://www.microsoft.com/technet/pr...y/dtssql2k.mspx

Good luck.

Sponsored Links