Browse by Tags

• bcp
• bulk insert
• bulk-logged
• error
• error log
• file
• i/o
• import
• jobs
• scheduled
• source
• SQL Server
• ssis
• truncated

• SSIS Error: Text was truncated or one or more characters had no match in the target code page

  This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format. Read More... Posted Wednesday, August 29, 2007 5:54 PM from SSQA.net | (Comments Off) Filed under: SQL Server, error, error log, jobs, ssis, truncated, destination, source, file, scheduled

• Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file

  When you use BCP then you would definelty get to see this error "Unexpected EOF encountered in BCP data-file". Not only that I have seen this as one of the frequently asked questions (FAQs) and for a moment you might be thinking why there is an end of Read More... Posted Wednesday, August 29, 2007 1:10 AM from SSQA.net | (Comments Off) Filed under: SQL Server, i/o, bulk-logged, destination, bulk insert, source, bcp, file, import