Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Must convert to DOS before bulk insert works

When I save results to file from my native SQL 2005 client.  I always have to convert these files to DOS in a text editor before a bulk insert will work on them.  What setting do I need to change in my client?
0
donnatronious
Asked:
donnatronious
  • 2
1 Solution
 
Bradley HaynesCommented:
There is no way you should need to convert file to DOS with SQL 2005. Maybe I should ask, what is your data source?

For conventional files (text/csv/etc)
Here is a guide:
http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html

Here is what Microsoft  (MSDN) has on the subject:
http://msdn2.microsoft.com/en-us/library/ms175915.aspx
0
 
donnatroniousAuthor Commented:
The data source is SQL Server 2005 client, save results to file.  
0
 
Bradley HaynesCommented:
Here is a guide to best practices for Bulk Inserts.
http://www.databasejournal.com/features/mssql/article.php/3095511

0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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