CREATE TABLE myTable99
(Test char(7), Test1 char(60), Test2 char(2), Test3 char(4), 
Test4 char(4), Test5 char(25), Test6 char(11),
Test7 char(7), Test8 char(10), Test9 char(8),
Test10 char(10), Test11 char(10), Test12 char(7)
)



exec xp_cmdshell 
'bcp DB_BOOKS.dbo.myTable99 format nul -S XIRDALAN-SERVER -f "c:\myTable.fmt" -c -T' 
select @@servername


BULK INSERT myTable99
   FROM 'C:\abs040123.txt'
   WITH 
      (
        FORMATFILE = 'c:\temp\myTable.fmt'
      )

cкачать

005283 BAKš BAō SóHIYYó IDARóSI                                     2 100               00010130606        1000        000        000        000        000         1000      1

CREATE TABLE myTable
(Test char(7),
 Test1 char(60),
 Test2 char(2), 
Test3 char(5),
Test4 char(4),
 Test5 char(20),
 Test6 char(12),
Test7 char(11),
 Test8 char(11),
 Test9 char(11),
Test10 char(11),
 Test11 char(13), 
Test12 char(7)
)


exec xp_cmdshell 
'bcp NorthWind.dbo.myTable format nul -S XIRDALAN-SERVER -f "c:\temp\Table.fmt" -c -T' 


select @@servername


BULK INSERT NorthWind.dbo.myTable
   FROM 'C:\Documents and Settings\Администратор\Рабочий стол\OBOROTKA-092.list.txt'
   WITH 
      (
        FORMATFILE = 'c:\temp\Table.fmt'
      )[src]