Browse by Tags

SQL Server Integration Services (SSIS) - learning materials and web resources for beginners

Published 7 April 8 5:38 AM | SSQA.net

Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs...

Filed under: sql server, package, ssis, search, BOL, dts, learning, source, web resource, beginner

Best practices for Data Importing using SQL Server native methods

Published 26 October 7 6:8 PM | SSQA.net

Ever wondered SQL Server Data Importing Do's and Don'ts, with a set of best practices. Import of data is a common task in any database platform and when it becomes regular you have to take care lot of incompatibilities. In particular SQL Server...

Filed under: sql server, data, best practices, import, testing, source, export, live data

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

Published 29 August 7 2:54 AM | SSQA.net

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...

Filed under: sql server, ssis, error, jobs, scheduled, error log, file, truncated, destination, source

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

Published 28 August 7 10:10 AM | SSQA.net

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...

Filed under: sql server, i/o, import, file, bulk-logged, destination, bulk insert, source, bcp