Transactional Replication perhaps?

CEWII

What is the scope of the variables, it looks like you are referencing them at the package level, if they are defined in the dataflow their scope will be different...

I have accomplished something similar, I did not use the deployment wizard though. I built *.cmd scripts that did several things. I built one for each environment. ...

I think that is an incredibly painful way to do it..

You can read the table in msdb called sysjobhistory to get all that information I think. The one thing...

I would say yes. Also, the connection still has to satisfy security on the server. I don't think MSDTC is particularly useful without this being set..

CEWII

Before your conditional split I would use a lookup to see if it is there, if so, set a value to one, if not then nothing will happen, for the...

64 or 32? Guessing 64..

Hardware looks pretty good. How are your drives laid out? Data on one volume? Logs on another? How many drives? ...

I have to recommend the Integration services method. It is the fastest and most reliable..

CEWII

Are the users sysadmins? If so then no, if not then probably.

CEWII

Pass-thru does not work. Period.

Changing the Black Box machine from integrated to mixed mode wouldn't change how that SQL server works with its current apps, and is really not...

Instead of defining it as a sub define it as a function with a return value of sqlint (I think thats how I did it)..

I did it in VB though..

CEWII

Great, I'm glad it worked for you, even though you had to tinker a bit..

CEWII

From the package store:

dtutil /DTS PackageToDelete.dtsx /DELETE

CEWII

You might try:

dtutil /SQL PackageToDeleteName /DELETE

CEWII

Try this

CEWII