I tried to backup tran Log by sql server maintenance plan, but it failed every day, below is the job failed error. I tried to fix but doesn't work. Can you help this? Thank you.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025:
[Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail:
failed with mail error 0x80040111
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.