I'm glad Sean posted already all the things that I wanted to say.  I've just read the article and it was obvious his stuff is from the real world, not...

We use Mark Sandy's approach as well.  Many of our stored procs deal with one table, and so the Module_Table_Action has worked EXTREMELY well.  If you want to see which...

It IS a very good article and a long time in coming.  We've been able to stretch the DTS considerably with setting global variables.  Never did get looping figured out...

Yes, I am logged in using the same name/password.  I tried to eliminate as many variables as possible.

I like the idea of it, and always love learning about new stored procedures, but chances are good I'd find a different way of getting to the output.

I share mom's concern.  That's why I thought using the Numeric as an increment, and then using a decimal (say .001) and starting out with the lower end of the...

I don't see an issue with using a BigInt, or any other number, maybe even using an increment smaller than 1 for a Float, for an even longer life span. ...

I was using SA to run the jobs, or sometimes run the job under my login.  The DTS runs fine when I execute it from Enterprise Manager.

We're using windows authentication on all server connections.  Must I use a SQL Server authentication?

I very much enjoyed the article and it provided a lot of useful information.  I have a stored procedure called RefreshDatabase that runs various maintenance scripts. I've included your reindexing...

The only catch on that is that WhateverTableName is on a different connection.  TableName is in Oracle and WhateverTableName is in SQL Server.

I've used this table structure for lookups, codes, two-field type situation for years.  Its been extremely effective and held under almost every situation.

CREATE TABLE [dbo].[LookUp] (

 [GroupName] [varchar] (25)  NOT NULL ,

 [EntryId] [int]...

I had been using the following style to run the DTS in a job:

exec master..xp_cmdshell 'dtsrun /S"ServerName" /E /N "DTS Name"'

and that's been working fine.  Could you give a...

That did it.  Thank you so much. 

I just tried out Grasshopper's Dynamic Properties Task Properties idea and it worked great.  Not intuitive at first but good potential.

Always something new to learn about DTS.  I put in boatloads...