Sure - you might want to start w/ an article Steve wrote a while back -

http://www.sqlservercentral.com/articles/Disaster+Recovery/sqlserver2005highavailability/2421/

What is the impact to the business if the database is unavailable for 24 hours or so? If the impact is minimal, then it isn't worth it.

If the folder returns black then the package is likely stored at the root - i.e. /PackageName. You can connect to the SSIS instance via management studio and verify this...

NP 🙂

Seems to happen to me every so often although I must admit I don't use the UI that much 🙂

What build are you running? Refer to -

http://support.microsoft.com/kb/937137

There are some fixes available in the post SP2 cumulative updates.

You can use a script task in SSIS as a alternative...

x64/IA64 offers is the native support of larger amounts of memory (resulting in a larger buffer cache), advanced parallelisim and threading, etc.

Assuming your going to be using Windows 2003...

You can use CAST or CONVERT - i.e.

create table #Blah

( SomeValue varchar(5))

insert into #Blah (SomeValue)

values(4)

go

insert into #Blah (SomeValue)

values(5)

go

select Sum(CAST(SomeValue as int)) as Total

from #blah

select AVG(CAST(SomeValue as int)) as Average

from #blah

go

There should be a save option. T-SQL is always cleaner 🙂

alter table Countries

drop column CountryID

go

alter table Countries

add CountryID int IDENTITY(1,1) PRIMARY KEY NOT NULL

go

You can use BIDS which is bundled with the SQL Server 2005 client software. VS Team Edition for Database Professionals offers source control amonst several other features that you may...

In SSMS, expand databases, table in question, triggers. Right-click the trigger in question and select the create to new query window and/or file option.

An example using the ICSSharpZipLib (http://www.icsharpcode.net/OpenSource/SharpZipLib/%5B/url%5D)

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Imports ICSharpCode.SharpZipLib.Core

Imports ICSharpCode.SharpZipLib.Zip

Public Class ScriptMain

REM Author: Tommy Bollhofer (thomas_bollhofer@symantec.com)

REM Last Modified: 03/12/2008

...

select b.foldername, a.name

from msdb.dbo.sysdtspackages90 a with(nolock)

join msdb.dbo.sysdtspackagefolders90 b with(nolock)

on a.folderid = b.folderid

You could alias the user as 'dbo' although this isn't a best practice and MS discourages it.

i.e.

sp_addalias 'testuser', 'dbo'

NP 🙂

Refer to BOL -

http://msdn2.microsoft.com/en-us/library/ms345172.aspx