This question is not detailed enough.

Please provide sample data, showing source data and desired output, as described in the link in my signature.

Files in the same folder cannot have the same name.

Best practice is to move your files to an archive folder after processing them - so the only files in the...

Why not just use a Foreach loop to process all files in the folder, regardless of name?

Or maybe *.txt - whatever works.

Do the files need to be processed in order?

You can say that again.

Or can you?

😀

If this code is driving an Execute SQL task and a number is required for a subsequent precedence constraint, the query should return a number!

IF ( SELECT COUNT(t.name) AS CheckQuery FROM (

SELECT f.name FROM fleets f

WHERE f.name NOT IN ( SELECT C.CompanyName FROM Company C

LEFT JOIN Accounts A ON A.CompanyName =...

steveb. (10/6/2011)

This is...

Please describe how to use that within an SSIS package.

I suggest that you read this to help your understanding of scope.

I can't give a specific answer, because that would require me to look into the design of your report.

But,...

Oooooooh, cool!! Maybe in five years we might have actually migrated to Denali 🙂

The error message seems self-explanatory: what is your question?

There's still no hint of a question mark there.

If I said: "I would like a new car," would you know how to respond?

If I said: "Can you for help me...

You have told us what you are doing.

Now take the next step and ask the question, or questions, to which you would like a response.

Maybe in another five years, the answer will instead be "select the desired value from the scope dropdown menu from within the variable's properties" 🙂

It will be there somewhere, as a tab/window - though possibly its position will vary from one PC to another, as the VS IDE is very flexible in the way...