all groups > sql server data mining > november 2006 >
You're in the

sql server data mining

group:

SQL Conversion


SQL Conversion Tony S.
11/8/2006 6:33:02 AM
sql server data mining:
I'm not even a novice on SQL, so this may be out of my league, but I need to
find out how to convert SQL Tables to Flat files. I imagine I will need a
converter of some sort, right? The scenario is... a subcontractor sent files
to us in SQL Tables unlike the last year when they were sent in a Flat file
format. How can we get this into a flat file format without having to incur
Re: SQL Conversion Dejan Sarka
11/8/2006 4:55:45 PM
[quoted text, click to view]

You can use the bcp.exe utility or SQL Server integration services. I guess
you would be quicker able to do what you need if you start researching the
bcp utility in SQL Books OnLine.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

AddThis Social Bookmark Button