Enterprise Business Rules · Module 7

bcp Import Exercise

Module reference

bcp Import Exercise

Write a Windows terminal command that imports C:\data\emp.txt into the existing, empty accounting.dbo.employees table on SRV1. Assume tab-separated character data with Windows line endings, no header, matching column order and types, and an authorized Windows account.

Use integrated authentication. Do not use a blank-password sa login or launch a shell from T-SQL.

Self-assessment: 20 points, four points each for the correct target, direction and path, server, authentication and format options, and a validation plan.

Compare with the model answer.