How come those 2 packages don't open in design mode?

Do you get any errors? How do you open them?

It shouldn't. I guess the version is specified because in the past there were...

Do all the Excel files have the same layout?

Otherwise your set-up won't work.

Is the @[User::FileName] variable populated with a design time default? Otherwise you won't see a thing when you...

And your connectionstring is... ?

The registry setting Lowell mentioned is the TypeGuessRow registry setting (for the JET provider).

There is a similar one for the ACE provider.

You can specify in the logging which events you log, so if you don't select the OnWarning event, warnings don't get logged. Or am I missing something?

Thanks for the book!

As you have noticed, the flat file will be generated even when there are no records written to it.

So you'll need to check the rowcount before the dataflow and based...

.

I guess that was the point 🙂

Putting UNION in the title would give the solution away.

Questions like these remind us that details are...

I would use plain old .NET to do this, but if I really had to use SSIS, I would use .NET in a script task 😀

OK, seriously now, this is...

That won't work unless you...

If you go to a garage because there is something wrong with your car, do you just say to the garage-owner:

"Here is my car. Fix it. I'll be back at...

Nice. First I just summed everything, but then I realized this would be too easy 🙂

Download BIDSHelper. It has a variable expression editor window that will allow you to paste multi-line SQL statements into a variable.

Fast Load has nothing to do with your Union All, so keep that setting!

(unless you like slow packages)

Apparently there is a problem with union all input 2. Maybe check the...