I haven't figured out global variables yet, but here is a solution that works for me.

The code is in an ActiveX Script task that is the FINAL step in the...

Hi,

I have a DTS package that works, and now I want to add the date to the output file name.

Where, exactly, does this ActiveX script go?

I tried adding it to...

Thanks for the article - I have been wanting to learn more about partitioning, and your explanations are so clear! In my case, I am dealing with a data warehouse...

Thanks again, Yelena.

What to I do when SQL Server is on serverABC, but the directory whose listing I want is on serverXYZ? I tried

            execute  master..xp_cmdshell 'dir

Thanks, Michael. I'll check out that thread.

Thanks a lot, Yelena.

Now just one more step: it works for the C:\ drive, but I need F:\Archive_bds2. Where do I insert that?

I need to know how to put your code into a cursor that the application program will process to print a report. My report calculates the run-times of a series...

amelvin, thanks for the great example. I'm a real beginner with CASE, but this is just what I need to do. I also need to put it into a cursor...