Thanks Craig .. Thats what I do to when I work on 2008R2. New to the world of parameter in 2012.

Did you find a resolution to the issue?

I relaise it is still an Execute task so the SQL will be run against the database.

Thank you for your reply.

Would it not be better to use a For Loop task with an Execute SQL task inside it?

Would this not make use of the...

Thank you this is very interesting .

Like you said I@m not sure how to map to the variables.

Is there anyway of being able to distinguish between the '?' variable...

Hi Daniel,

Many thanks for your reply.

I was using an Execute SQL within the For Each Loop.

Could you please give an example of the 'variable to build your entire...

Thank you all for your replies.

I need the file parts from the source data folders.I have attached a document with some diagrams of the folder structure.

If you have any suggestion...

Thank you very much 🙂

Thanks to your explanation I know how it works internally now .. I was under the assumption until the whole package runs may be the data...

Thank you .. I will give that a try

Hi Koen,

Many thanks I will give that a go. Would thae expression capture all "0.0" or "0.00*" amounts?

Appreciate your help on this.

Regards,