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 Services process to generate a dump file when the process experiences exceptions ...

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. Then the string MM/DD/YYYY is converted to a date in a Data Conversion flow. And finally ...

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 file. So better to check the match between the source file columns that are imported and the ...