After successfully importing multiple text files using SSIS (MS SQL 2008 R2 ETL Package) into a SQL table, I’d like assistance with the following:
Create a report which provides detailed information on the status of a package and descriptive statistics (e.g. number of rows, time frame of completion, warnings, and error messages etc.) Automating delivery of the reports in the following formats (HTML, TEXT, and XML)
Detailed procedures, code, URL’s, and/or video webinars would be much appreciated. Thanks in advance for the support and guidance.