Search results for 'app:weblogs' matching tag 'scheduled'

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

Anonymous — Wed, 29 Aug 2007 05:00:00 GMT

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 the data is put into a SQL Server table (currently with no rows). There is a temparory table involved here to import rows and then eventually the relevant...(read more)

Delete DEMO alerts from SQLAgent

Anonymous — Fri, 25 May 2007 05:00:00 GMT

Since the days of SQL 70 automated administrative tasks are getting better with the usage of SQLAgent, you need to know how to configure alerts and set up operators, the people SQL Server contacts when alert conditions arise. SQLAgent Jobs can trigger alerts, for example, when a scheduled job fails or when a log file fills up. You can also define alerts to trigger jobs in response to an alert condition. By default SQL Server will get installed with Demo alerts and you can leave them as it is or drop...(read more)