sql server dts: Hi

I know that this is possible, because I've done it before... actuallly it was about two years ago when I came up the the solution on this newsgroup..

So hopefully there's someone out there with better memory.

This is what I need

I want to load all the excel files found in a particular directory (in other words the source must be variable) - I remember doing something to a global variable...
And then I want to throw all the files I loaded into a new directory..

Who can help

Thanks in advance

This is probably the thread (from almost an year ago):
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&th=288d
97ad6d299778&rnum=4

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
Hi,

I know that this is possible, because I've done it before... actuallly it
was about two years ago when I came up the the solution on this newsgroup...

So hopefully there's someone out there with better memory..

This is what I need:

I want to load all the excel files found in a particular directory (in other
words the source must be variable) - I remember doing something to a global
variable....
And then I want to throw all the files I loaded into a new directory...

Who can help?

Thanks in advance!
Ana