Apply SSIS 2008 to copy files associated with similarly named variables in an XML config file

Question

1.00/5 (1 vote)

See more:

Hello,
I currently have an XML configuration file called ProjectFiles.dtsConfig created under SSIS that contains five variables SrcFile1, SrcFile2, SrcFile3, SrcFile4 and SrcFile5. Each has a value defining the location and name of a unique file, where each can be in a different location. Over time I will be adding and removing the file variables from the config file, but the variable names for the files to be copied will always begin with "SrcFile".

Is there a way, using expressions or scripting or whatever, to dynamically loop through and copy the files associated with variables in the schema file that begin with "SrcFile"? I have looked into applying different enumerations under the Foreach Loop Container in an SSIS package and would like to avoid hardcoding the variable names (SrcFile1, SrcFile2, etc.), as there may eventually exist a SrcFile6, SrcFile7 and so forth in the future.

Thanks,
Kosh2010

Posted 7-Aug-12 6:54am

Kosh2010

Updated 7-Aug-12 10:01am

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 7-Aug-12 12:56pm

Not a nice question. If you have a problem you cannot solve, just describe it, don't tell us what to use to solve it (like in "apply foreach loop")...
--SA

Kosh2010 7-Aug-12 13:20pm

Sergey,
Do you mean that it was not a "proper" or "good" question? Saying that my question was not "nice" implies that it hurt your feelings, which hopefully is not the case.

I've successfully applied the Foreach Loop container in the past and it seems like the most appropriate approach here. But I am certainly open to alternatives. If you have experience with SSIS and have a better idea, please share.

Thanks

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kosh2010 · Accepted Answer · 2012-08-09T07:03:00

I have decided to change my approach with regard to the objective of this issue. The objective is to iterate through a specific list of files defined in a list of other files and copy them from different locations to a single location. Instead of defining the file paths using variables in an XML configuration file, I've decided to define the file paths in a new database table where it is much easier to capture the list of files using an Excecute SQL Task and then passing that result on to a Foreach Loop container that will apply a file system task of copying each file using the passed file enumerator. Maintenance with this approach is also simpler. This approach resolved the issue and was easy to set up.

Using an XML configuration file in the original approach defined is not practical.

Thanks,
Kosh2010