I don't agree with calling this tricky. It's only tricky if you start making assumption about what might have been intended as opposed to what is actually there.

Try setting the BufferTempStoragePath property for the Data Flow task to the other drive you want to use.

Try replacing "@count = @count + 1" with "SET @count = @count + 1"

I believe MCTS (Microsoft Technology Specialist) is one of the lowest levels of certification Microsoft offers. MCTS certifications only cover "narrow" topics.

To get the MCITP for SQL Sever you...

The normal way to do this is to setup a linked server pointing to the other server. You can then access it's data by using ServerName.databasename.Schema.tablename. You should...

To do what? You only need that if you want to execute another package from within that...

If you want email notification on the individual steps then that should be programmed into each package.

SQL jobs notify after the job completes, not after each step.

If anyone knows better then please correct me if I'm wrong.

I like what I can do with Visio for a reasonably low cost. The problem I have with Visio...

There might be another good reason to upgrade to 2008.

First let me say that I'm not on top of all the latest developments.

Did M$ fix all the 2005 bugs? ...

Can we get a bit more information?

You want B to run after a successful run of A. What do you want to happen if A fails?

I suspect you can...

I feel your pain Barkingdog.

I went thru the same thing. I'm so disappointed at Visio for not being to push the design to a database.

The query expects eventstatus_bek_IGA to already exist. Does the table exist?

Garadin (10/9/2008)

---

Rather than updating 1000 SP's, couldn't you just create a view named what the table used to be that references the new database / table with a SELECT *...

Where I'm working now, for the non-system databases, we typically do transaction log backups every 30 minutes; differential backups daily; and full backups weekly.

We do a full backup of system...

Because sometimes the data you want does not lie in just one table and you have to query all the required tables at the same time in order to get...