Bulk insert fixed width fields

by

I think you need to define a format file

e.g.

BULK INSERT TableA FROM 'C:\Temp\TableA.txt'
WITH (FORMATFILE = 'C:\Temp\Format.xml')
SELECT * FROM TableA

For that to work, though, you need a Format File, obviously.

See here for general info about creating one:

Creating a Format File

At a guess, from looking at the Schema, something like this might do it:

<?xml version="1.0"?>
<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
  <FIELD ID="1" xsi:type="CharFixed" LENGTH="3"/>
  <FIELD ID="2" xsi:type="CharFixed" LENGTH="3"/>
</RECORD>
<ROW>
  <COLUMN SOURCE="1" NAME="Field1" xsi:type="SQLCHAR" LENGTH="3"/>
  <COLUMN SOURCE="2" NAME="Field2" xsi:type="SQLCHAR" LENGTH="3"/>
</ROW>
</BCPFORMAT>

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. What is the best way to create and populate a numbers table?
  3. Sql Server string to date conversion
  4. SQL Server query to find all permissions/access for all users in a database
  5. SQL Server IN vs. EXISTS Performance
  6. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  7. PIVOT in sql 2005
  8. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  9. Atomic UPSERT in SQL Server 2005
  10. Do I really need to use “SET XACT_ABORT ON”?
  11. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  12. SQL Server ORDER BY date and nulls last
  13. How to determine total number of open/active connections in ms sql server 2005
  14. How to remove accents and all chars a..z in sql-server?
  15. Find non-ASCII characters in varchar columns using SQL Server
  16. How to query values from xml nodes?
  17. How to query for Xml values and attributes from table in SQL Server?
  18. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  19. What happens to the primary key Id when it goes over the limit?
  20. What is the point of “Initial Catalog” in a SQL Server connection string?
  21. How do you kill all current connections to a SQL Server 2005 database?
  22. SQL Server recursive query
  23. Milliseconds wrong when converting from XML to SQL Server datetime
  24. nvarchar(max) vs NText
  25. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  26. Date range overlapping check constraint
  27. “Prevent saving changes that require the table to be re-created” negative effects
  28. Convert UTC Milliseconds to DATETIME in SQL server
  29. Table Valued Function Killing My Query Performance
  30. @@ERROR and/or TRY – CATCH

Leave a Comment