Are you sure that the second package is showing a failure on execution?

What about if you set the three packages as 3 steps in a job?

I've tried Spotlight, and we purchased it at my previous company, but told them to take it back as it gave too many false positives, oh and we did have...

1 - not experience this myself. The answer was definately not good however.

2 - New version supports this from my understanding.

3 - New version logs to sql

4 - Not experienced...

I think that it has a lot to do with the fact that they are a relative newcomer into the market and trying to build a strong customer base.

Take Imceda...

You must have the updated version. Gonna have to make some calls and get me that.

I'm using it currently and it's in my top 5 tools, all time.

The setup is very simple and basic, it captures and reports relevant information, shows it graphically which is...

If you look at the sp_attach_db procedure it actually uses the CREATE DATABASE FOR ATTACH syntax, you can just extend that as you need. You could even create yourself a...

It may be that Erwin is better, but I think that they are using the Viso for .net architects aspect of the development tools in an attempt to supplement the...

One thing missing from the list which is extremely useful...Taskpad.

Go to a database, then hit view-->Taskpad, it will give you a reperesentation of the database, along with log and data...

I've been using this since it was SQLEd, prior to Apex purchasing it, and was fortunate enough to get it for under $50 back then. They've improved the product immensely...

Very powerful, very useful, but can seriously mess you up if you don't know they are there. Had an issue once where we called a virtual MACH. We tried to...

You should check out http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm

Dynamic disks shouldn't really be used with SQL, however they are less of a concern in a normal scenario, the biggest problem comes if you try to use dynamic disks...

The other problem is that you can't pass dynamic parameters into an openquery. You need to dynamically build the sql and then execute it...

declare @dates varchar(6), @sql varchar(2000)

set @dates =...

You must have misread, I run a remote distribution cluster for a couple of my clustered publication nodes without any problems. In fact performance replication wise was vastly improved by...