Insert from Flat to SQL

SQL Add comments

Step 1: Create a Destination table

Step 2: Create Schema File using Notepad
Save this file with “.FMT” Extension (for example: bcp.fmt)

Step 3
Create the following Store Procedure [Text_File_Bulk_Import] to import Text file data to Destination Table [Customer_Sample]

Execute the Store Procedure [Text_File_Bulk_Import]

link to full article

Leave a Reply

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in