If you are restoring the reporting database from live server just to get the data, and you do not need all whole live database for reporting. Then try to create...

Mike,

Are you interested in upgrading your environment or you want the answer for the current environment? Even in current environment you run many of the DTS's every 15-20 minutes. I...

You have to write everything in DTS ActiveX script, you can not use Designer tools. Inside the ActiveX script you can change all the properties dynamically. Let me know if...

If you have some fix pattern for your table name like.

"fixString" & month & year

then you don't have to change the source table name in DTS package,whenever you change...

It all depends on at what time of the day your DTS scripts are scheduled to run. If there is no traffic on server when you run your DTS then...

ActiveX script in DTS does not use the T-SQL language, it uses VBScript or Javascript. So for using isNull in VBscript try following:

If isNull(DTSSource("myCol")) Then

    DTSDestination("myCol") = "Your custom value"

Else

  ...

You can use COALESCE function also..

Select COALESCE(fieldName, 1) from myTable

- Kamlesh