Hi,

I use to import data from multiple source files but those files are in the
same folder
Now I've got same files (ie. with the same name) but in different folders
And I want to import all of this in the same table
I've got 2 global variables :
- gv_FileLocation
- gv_FileFullName
So for exemple: gv_FileLocation = D:\ftp\Paris
And another folder => D:\ftp\London

How can i switch folder in the same DTS package ?

Rgds
Flora

You'll have to use the Activex Task and loop though the folders and change
the name of the location / file.

Check out this tutorial..

http://www.sqldts.com/default.aspx?246

It shows you how to do the looping and the setting of the file names. (or
folder names in your case)

Bill


"Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> wrote

I have used something like this and it works great.

Rick

"Bill Swartz" <wsaharem (AT) yahoo (DOT) com> wrote

I already use this package and yes it works very well for multiple files
But I want to imbricate a loop for multiple folders AND for multiple files
Which intance should I use ?
Wich global variables should I create ?
Can you suggest a code that imbricate this 2 loops

Rgds, Flora


"Rick Gittins" wrote: