(For more information about Sqlcmd, see "Sqlcmd"; for related articles about SQL Server 2005 and SSIS, see the Learning Path below.) In this article, I explain how to use Sqlcmd and SSIS to construct and populate the DBA_Rep repository database.
In a later article I'll explain how to build and deploy the three SSRS reports designed to deliver the data from this repository.
End Error Error: 2013-10-01 .05 Code: 0x C0024107 Source: Load Excel File Description: There were errors during task validation. This means that often my servers will only have the database engine installed and possibly a few other features (such as Integration Services) as needed by the system.
End Error DTExec: The package execution returned DTSER_FAILURE (1). In most situations, there is no need for developer tools on a production server, therefore, BIDS and other components are omitted.
I therefore developed a fairly simple solution that connects to each available SQL Server machine, pulls information into a central repository database, and feeds the combined data to a report for DBAs and other IT staff to use. (Note that the solution I offer is intended to enhance, not replace, a preexisting full monitoring and alerting solution.) Several tools are available to the intrepid DBA setting out to discover the uncharted server landscape.
For example, you can use the Microsoft SQL Server Health and History Tool to populate a repository database.
The SQL Server Import and Export Wizard is useful for copying data from one data source (e.g. Although the interface is fairly simple there are a few “gotchas” to be aware of.
Here are a few issues I’ve found while loading data from one SQL Server database into another.So I open the Local Users and Groups manager (lusrmgr.msc) and checked the group membership of my account.I found that it was a member of the Administrators group and a Home Users group, but not a member of the Users group.However, this tool is outdated and not very flexible.(For more information about SQLH2, see "SQL Health and History Tool," November 2006.) For my project, I employed the command-line tool Sqlcmd, SQL Server Integration Services (SSIS), a SQL Server database for the repository called DBA_ Rep, and SQL Server 2005 Reporting Services (SSRS).End Error Error: 2013-10-01 .05 Code: 0x C004700C Source: Load Excel File SSIS.