Forum Topic

Thanks for your participation and contribution.


Back to SQL Server

Bulk Insert into SQL Server

Post a reply
748 views
i90runner1
i90runner1
Bulk Insert into SQL Server
 

-- Bulk Insert into SQL Server
   BULK INSERT rs_eventsv2_ewh_dp_me_prd_bkp_03212018
   FROM 'G:\FileShare\Data\0000_part_00.001'  
   WITH   
      (        DATAFILETYPE = 'char',  

         FIELDTERMINATOR ='|',  
         ROWTERMINATOR ='0x0a'  
      );


https://www.mssqltips.com/sqlservertip/4648/sql-server-bulk-insert-row-terminator-issues/
https://docs.microsoft.com/en-us/sql/relational-databases/import-export/specify-field-and-row-terminators-sql-server?view=sql-server-2017

Last updated

1-1 of 1

Reply to this discussion

You cannot edit posts or make replies: You should be logged in before you can post.