Browse by Tags

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: An attempt was made to send an email when no email session has been established.

Published 31 July 7 4:51 AM | SSQA.net

What to do when you get the error specified on the subject above? You might get this error message from a job which will send email to an operator when it is completed. First thing to check whether a valid email has been mentioned in the operator. Also...

Filed under: sql server, jobs, notification, error log, dbmail