[thelist] DTS Task

[James Conley]

Alternatively - would it be possible to define what the Excel document
is picking up in the form of an Excel Web Query? If so then you might
could create your excel document with a web query and place it in a
shared drive once and it would update itself when you opened the
document. [I say that without ever having worked with web queries
however so I don't know their limitations]

james c.

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Joshua Olson
Sent: Monday, March 06, 2006 9:26 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] DTS Task

> -----Original Message-----
> From: Rob Smith
> Sent: Monday, March 06, 2006 9:16 AM
> 
> I can set the time frame of the query to look at the past seven days. 
> It would be ideal to tell DTS to go to a web page and capture the 
> output into an excel document, then put that on the shared drive.  All

> I'd have to do is retrieve the document.
> 
>  
> 
> Can this be done? And how?