Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
BCP command line and Format file
Is DTSRun and alternative? This would give me the command line nature of the utility with the import 'power' of DTS. Is this a reasonable option?- pi4paul05
- Post #5
- Forum: Microsoft SQL Server: Data Transformation Services
-
BCP command line and Format file
Yes, you are correct! The first record has a Name of "Leary" and an Address of "Mark". Is there a way to tell BCP that the data that is seperated by commas is double quoted. I can import this file using a DTS import package, but I would rather use BCP because of the command line nature of the...- pi4paul05
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
BCP command line and Format file
I am having difficulty importing a fairly simple text file into SQL Server using bcp. The following is an example of a text file I am trying to import along with a command line that I am using to run bcp. NAME,ADDRESS "LEARY,MARK","10943 IRONWOOD RD" "COSGROVE,CHRISTOPHER","7414 MESA COLLEGE...- pi4paul05
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Data Transformation Services
