The server you are running from needs to be able to access the file location on the other 2 servers. You can then write the file path as \\server\(etc.)...

I hope this copies ok from my Word document. I was able to create and load tables from flat files where the names are not known in advance.

If you...

Thanks! That is what I was missing.

An alternate approach is to have a work table that you drop and create each time that has a standard name (wkFileData, for example). Load the data here first....

What did you have to do to get DirectoryInfo to be recognized? I have a similar application but get an undefined type error on my dim statement for dirInfo.

I...

Thanks! The amount of data that needs to be passed is small in this case. But this gives me 3 different approaches depending on the situation.

Do all the files have the same format? Is the format known in advance?

Thanks!

Thanks! I finally got a chance to experiment Friday afternoon at work. It looks like it is possible if you let the child reach into the parent for...

Thanks! I will try that out tomorrow.

Thanks. It looks like this requires an execute package task for each possible child package. There could easily be a hundred different file formats so I was hoping...

If the files are all in the same folder, you can use a for each loop to process them one at a time. It lets you put the file...

Not yet. I wish there was a way to reach the authors.

I am an Informatica developer in a small company that has decided to switch to SSIS. Informatica licenses by the number of Informatica repositories and the characteristics of the...

One possible approach is to first move the files in \Prior\ to \Archive\.

Then run your foreach loop through the files in \Folder\.

When you finish processing each file, use the saved...