Error occurred during the creation of the DTS Package

This morning I received a call from a client who were receiving the error “Error occurred during the creation of the DTS Package” whenever they attempted to open the SQL Server 2000 DTS designer by either editing a package or attempting to create a new package.  This error often occurs when there is an issue with the registration of the problem with DTSPkg.dll.  The DTSPkg.dll can be found in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn directory.

In order to resolve the issue the dll needs to be re-registered using Regsvr32.exe.

ie.

Regsvr32.exe “C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSPkg.dll

Move a Database to a new Location

A database data or log file can be moved from one location to another using the following steps:
— 1) Detach the Database
EXEC sp_detach_db test
— 2) Move the file that was detached to the new location
— 3) Attach the Database from the new location
EXEC sp_attach_db @dbname = N’test’,
@filename1 = N’c:\foo\test_data.mdf’,
@filename2 = N’c:\foo\test_log.ldf’
For more details regarding moving database files including Model, MSDB and TEMPDB refer to
http://support.microsoft.com/kb/q224071

Free Software Utilities

WARDY IT Solutions have just released two software utilities which we have made available for Free. We recently developed these utilities to assist us to solve specific problems that we have encountered.  We have made these utilities available in order to assist you with solving similar problems that you may encounter.

DateMod is a Graphical utility which can change the Date Modified and Date Created properties for a single file or all files in a directory.  Download from http://www.wardyit.com/apps/DateMod.zip.

UnixToDos is a command line utility which can change the newline character for a single file or all files in a directory from a UNIX newline character (LF) to a DOS newline character (CRLF).  Download from http://www.wardyit.com/apps/UnixToDos.zip.

When downloading these utilities, please consider making a donation so that we can continue with the development of future versions of the products.

SQL Server System Administration Essentials

I will be running the course ‘SQL Server System Administration Essentials’ in Brisbane on Monday the 20th March 2005.  This course is a one day course which has been designed to assist students to develop the technical skills and confidence to manage Microsoft SQL Server 2000 in order to meet the constant demands of business.

For more details regarding the course refer to
http://www.wardyit.com/courses/MicrosoftSQLServerSystemAdministrationEssentials.pdf.

If you require any additional details regarding this course or if this course is not being run at your preferred time or location then please do not hesitate to contact us so that we can assist you.

When:
Monday 20th March 2006

Location:
Cliftons
Level 1
255 Adelaide Street
Brisbane

SQLSMO – Adelaide SQL Server User Group

I will be attending the Adelaide SQL Server User Group on Thursday the 9th March 2006 to present on the SQL Management Object (SMO).  Below is a synopsis for the presentation as well as the details of where the presentation will be held.

For more details regarding the Adelaide SQL Server User Group and to register your attendance for this event refer to http://www.ineta.org/desktopdefault.aspx?tabindex=1&tabid=27&groupid=2010.

Presentation Synopsis:
Do you find that day-to-day in your job you are ‘fire-fighting’ issues that could have been prevented if you had the time to perform proactive monitoring of the SQL Server instances in your enterprise; Or maybe that you would like to implement an enterprise management solution but are restricted by budget constraints?  In this session, Peter Ward from WARDY IT Solutions (www.wardyit.com) will introduce the SQL Management Object (SMO) and how applications and scripts can use this object to access the management features of SQL Server 2005.  In this session Peter will demonstrate how SMO can be applied in the enterprise to assist in automating common administrative tasks as well as to extend the functionality of SQL Server.

Location:
Level 2
Santos Building
Cnr Currie & King William Streets
Adelaide
Thursday, 9th March 2006, 12:00-14:00