Browse by Tags

• bcp
• bulk insert
• bulk-logged
• destination
• dump
• error
• error log
• exception
• i/o
• import
• Integration
• jobs
• kba
• process
• scheduled
• services
• source
• SQL Server
• ssis
• truncated

• How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to enable the SQL Server 2005 Integration Read More... Posted Friday, August 31, 2007 5:56 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Integration, services, process, ssis, kba, exception, file, dump

• 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