steven.malone (12/17/2010)

---

You mentioned "DTS lead to SSIS"

More like Microsoft threw DTS under the bus and brought out SSIS.

I think the most under appreciated feature was the ability to create system...

I think Craig hit it on the head.

I personally refer MSDB because I want all my database stuff backed up together and not have to worry about the...

Given the way these packages work they try to insulate the OS from the HW so it is kind of hard to determine.

You could likely look in the...

I think I might have answered part of my own question:

http://msdn.microsoft.com/en-us/library/ms189940.aspx

"In a log shipping configuration, database snapshots can be created only on the primary database, not on a secondary database....

MidBar (11/13/2010)

---

Again thanks Elliott,

Well first thing in my scenario, as i said keep the most required records in Live. So steps i want to perform here are

1. Prepare a staging...

First I almost never use the environment variable as a config location, the main reason is that it is difficult to version control, a little more complex to set and...

First DO NOT EVER USE MERGE with an SSIS package, EVER EVER EVER.. Ok, just trying to be clear..

An SSIS package is really a big XML file that...

You are very welcome.

CEWII

The config file can be anywhere that the process can reach it, so I'm not sure that is your problem. However, whatever the path to the config file is...

Ok, first of all what is your package protection level? By default it is EncryptSensitiveWithUserKey..

Within the package, right click on a clear spot in the control flow and choose...

I'm not sure you read that entirely correctly. That table seems to only talk about version upgrades to SQL 2008 R2 Versions, but I did find that 2008 Web...

I want to add on to what Steve was saying. Some (many?) of the open source databases have licensing models that if you use them purely in-house you don't...

I believe this information is only stored in the SSIS package. You can use the object model in .NET to walk through the package and pick that information out.

CEWII

I am not quite familiar with this part, please advice:

1. During development, use the local DB as connection string to build the SSIS package, and then use package configuration to...

Whoa, it sounds like you are running a two node cluster and Server A is the primary and Server...