Common bcp Issues

Common issues that arise when bulk copying data include:

• Copying data between different code pages
• Using delimited identifiers with bcp
• Loading ASCII files
• Native format bcp and improperly defined tables
• Finding hidden characters in data files
• Using default data type sizes
• Copying date and money values
• Importing image data
• Copying data containing identity values