You can do it with a global variable, but the trick is that the query has to follow Progress syntax, not T-SQL syntax. From memory we used a date format...

The PRINT statement just performed an implicit conversion of your nicely converted datetime to varchar

How are the files named? If like most backups, they have a datetime stamp you can use that to weed out files.

eg: For a file name like myDb_tlog_yyyymmddhhnn.trn you can...

What account are the SQL services running under?

Have you looked at the log files on the server Reporting Services is running on?

As long as SP4 is applied, Query Analyzer will still function on an SQL 2005 system.

It's actually still my tool of choice to get things done quickly

Well given the structure posted

- How do I get the "True" value for Monday?

- How would I get the same value if the node was Tuesday and the Monday node...

Haven't had a chance to look through the other schedule tables at the moment. If you've got any ideas on how to use the XML data as it is that'll...

Ok, that's working for the Parameters and ExtensionSettings columns. Now I've struck an iceberg while the scheduling information. The column is called MatchData in the subscription table.

Here is a sample...

The layout and annotations in DTS are not part of the object model. Therefore any modifications done outside the Designer GUI will cause them to be lost.

May I suggest that...

Take a look at sp_dump_dtspackagelog in the msdb database.

Deleting from sysdtspackagelog will cascade to the step and task logs.

Jacob, thanks for that. How do I run this across a table?

The subscription table in the Reporting Services database has three fields with XML values that I'd like to break...

???

I work with SQL Server and don't know anything about Sybase. Maybe you should ask on a Sybase forum, or Google it http://www.google.com/search?q=Sybase+OLEDB

The TCP/IP protocol will give you the best...

1. Yes there will be a slight performance degradation as ODBC sends a lot more messages back and forth between source and destination. There's nothing you can do about that,...