Steve was nice enough to tell me how to post an attachment.

I have attached a zip file with a word document containing some basic instructions and some pictures.

I'm clearly blind, stupid, or both.

Thanks

It's the old argument regarding where business logic should be managed and what is business logic. Arguably, foreign keys are business logic, so some developers want to put this...

For the ordering and fragmentation problem, SQL 2005 has a function NEWSEQUENTIALID() that can be used in a default to solve this issue.

If you have a big, multi-server environment and...

Assuming you have a primary key (or some unique key that cannot be changed on a record) you can do this very easily.

Look at the SCD wizard.

Yes, it is true...

MS SQL does not really support this.

This is not a typical thing to do. I remember seeing a product that someone sells to do this. I cannot remember...

Again, I would not recommend doing it this way, using error handlers to drive control flow is going to lead you to a list of other issues.

Your problem is probably...

You could not set the task as disabled in the expressions for the task because the task would already have the control when the expression is evaluated. You may...

Reporting Services 2000 and 2005 and managed virtually the same. 2000 uses Visual Studio 2003 and 2005 uses Visual Studio 2005 for creating reports. Both versions of reporting...

Look for CAST and CONVERT in books online

It will depend on your statement passing the specified criteria.

The first option (with the AND's) will resulve all of the EXISTS criteria every time.

The second option (nested IF's) will only...

I am unfamiliar with ProvideX, but it sounds like you are able to run a SELECT statement, look at the data, and then run an UPDATE statement when done. ...

That may actually depend greatly on your data, but in a quick test on one of my production databases:

SELECT * FROM AccountMaster WHERE AccountID IN (55,74)

GO

SELECT * FROM AccountMaster WHERE...

Configure the replication using SQL 2005 Management Studio rather than using Enterprise Manager. You can do this either by setting up the entire replication from the 2005 side, or...

I don't think this is what you want to do. If you are just trying to test the entire package on a sample set, you probably want to reduce...