Creating SSIS Package Error

Comments Off

Error
Failed to save package file “C:\TEMP\tmp18D.tmp” with error 0x8002802B “Element not found”. Turns out that this is due to MSXML6 not being registered.

Solution
To register MSXML 6.0.

  1. From the Start menu, click Run.
  2. Enter the following command: regsvr32 %windir%\system32\msxml6.dll
  3. Click OK

Sending Appointments to an Outlook 2007 Calendar from an ASP.NET 2.0 Web Site

Comments Off

Good article that uses VS 2005 to create an ASP.NET 2.0 web site that can create and send an calendar appointment to add to an Outlook 2007 calendar. Examples in both VB.NET and C#
http://msdn.microsoft.com/en-us/library/bb655909.aspx

Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.

Comments Off

The cause of this problem is the SQL server has been configured to operate in “Windows Authentication Mode (Windows Authentication)” and doesn’t allow the use of SQL accounts. This was the default setting in my case, I got the error after installing a new instance of SQL Server 2005.

I was able to solve this problem by changing the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)” to “Mixed Mode (Windows Authentication and SQL Server Authentication)”.

The log file for database ‘dtsPackageName’ is full.

Comments Off

DTS error:

The log file for database ‘dtsPackageName’ is full. Back up the transaction log for the database to free up some log space.

Solution:

backup log epack_dev with TRUNCATE_ONLY

Getting Database Stats

Comments Off

You could use

sp_helpdb [ [ @dbname= ] 'name' ]