How to Find the Causes of SSIS Package Failure in SQL Agent

In this article, we will discuss how to get list of packages related to SSIS, connection issues in data store, key access problem in files and protection level for package, SSIS source speed and log logics. If we do not apply necessary functions in our SSIS package then console outputs or windows events logs will show small number of errors. But if we enable the logging function in SSIS then it is a completely different scenario. In general, we can work with five different places that...

Read more »

8 Ways to Set Different Background Colors for Header, Footer, and Main Document in Word

In this article, we plan to provide you 8 ways to set different background colors for header, footer, and main document in Word. By default, to set a page color will make all parts of the document in the same background color, including the header, footer and main document. What if we want to set different background colors for these 3 parts? To achieve so, we will have to deploy some workarounds, such as follows: Method 1: Insert a Shape into Header or Footer Let’s take the example of...

Read more »

How to Quickly Compress All Attachments into a Zip File in Your Outlook Email

Sometimes, you may want to compress all the attachments in an email into a zip file directly in Outlook. In this case, you can use the VBA code introduced in this article to achieve this feature. By default, Outlook has its attachment size limit – 20 MB for POP3, IMAP or other web-based email accounts and 10 MB for Exchange accounts. So, when the total size of attachments exceeds the limit, you will get related errors. In this case, it is a good option to compress all the attachments into a...

Read more »