BCP in to SQL DB

• 1time@bandcamp

  SSC Enthusiast

  Points: 187

  More actions

  August 5, 2019 at 10:41 pm

  #3668980

  Hello, I'm trying to import some data from a .dat plain text file to SQL using the following BCP command.

  bcp dbname.dbo.tablename in DataFile.dat -f format.fmt -F2 -T -S "servername, ####" > bcp.log

  After the data imports to SQL. We have a tab at the start of our data for each row in the first column of the table.

  Our Datafile.Dat has a tab at the end of each line to define a new line. I have attached a sample of our format file.

  Any help would be appreciated. 🙂

   

   

  • This topic was modified 5 years, 3 months ago by  1time@bandcamp.

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 6, 2019 at 11:10 pm

  #3669324

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.