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”
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
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