Google Buzz – Web 2.0 Narcosis

I love the idea of Web 2.0 – I jumped on the social networking bandwagon at a fairly early stage getting involved with AOL’s attempt to compete with myspace with its AIM pages. Its great that people with shared interests can join a network and interact with each other in a way that couldn’t be done before.

And I currently maintain profiles at LinkedIn, flickr, facebook & twitter, youtube, picasa, pprune.org and SSC. These profiles I can handle quite nicely along with my own hobby sites and various shopping websites that I use. I have always argued that privacy concerns can be managed Continue reading “Google Buzz – Web 2.0 Narcosis”

Bulk Import of DTS 2000 packages to SQL2005

I recently saw some forum posts on SSC.com asking if there was a way to bulk import DTS 2000 packages into a SQL 2005 database.

The answer is that you can use the DTSBackup utility available for download at www.sqldts.com. Its a lightweight and extremely useful tool that can save hours of mouseclicking, and it works on both SQL 2000 and 2005.

Amazon Link: SQL Server 2000 Developer Edition

SSIS Logging in dbo.sysdtslog90

I was recently asked if you can only use the msdb.dbo.sysdtslog90 table to log SSIS package execution…

It is possible to log your SSIS execution to a database other than msdb, simply by scripting the sysdtslog90 table from the msdb database, and creating it in a new db.

Then when you configure your SQL Server log provider, use a connection manager that points to the database on which you’ve just created your table.

Amazon Link: Microsoft SQL Server 2005 Integration Services Step-by-Step