There is no difference between the package that worked and the on that failed. I ran it the first time and it worked. I then saved it and ran...

Thank you very much. That worked really well. With this knowledge I can expand my package.

Thank you for the book. i have already ordered it.

I think I may have made my problem more complicated than it was. I did the same task in DTS but...

I am a bit of a beginner when it comes to ssis so please bear with me.

Firstly how do I create an excel template? Is this done with an...

I have managed to get the backup to work. I deleted two of the backups in the folder and nightly schedule ran smooth. Two of the backups had become corrupt...

My desired result is to count the number of attendances as activity and sum up the cost. However where I am selecting the cost i need to select the highest...

Many thanks. It works.

I have changed the exec statements to select and they execute.

Incidentally the SQL-Server instance sits on a virtual server. I am wondering if that might have any impact. We...

The BACKUP Command is shown below

DECLARE @securedb varchar(255)

IF EXISTS (SELECT * FROM NWCSCMDSData.dbo.sysobjects WHERE id = object_id(N'NWCSCMDSData.[dbo].[GPSecureDatabase]') AND xtype = 'U')

BEGIN

SET @securedb = (SELECT TOP 1 GPSecureDB FROM NWCSCMDSData..GPSecureDatabase)

END...

After looking into the scenario more closely I have found it to be an authentication issue in a double hop scenario. By deploying delegation with configured Kerberos I managed to...

Many thanks. That explains a lot. Cheers

I put that in and it worked. Could you explain how you knew where to put it. I thought the statement COLLATE SQL_Latin1_General_CP1_CI_AS would be with the BRENTREPODB02 alias?

I have carried out the inserts and outside of the stroed procedure and it works. However when I run the stored procedure I get the error message.

Thanks. It is working now.

Thanks, you were right about the wild card. It now returns what I want.