Use a query as your source and do the CASTs in the query?

No need to apologise and the question was not stupid.

Feel free to post more questions as you work through.

You may be able to use a MULTICAST to achieve this.

Understandably. Does it always process exactly 44 rows? If so, can you try reading in the...

Check the source data in row 45. There must be something 'different' in it which is causing the error...

To have figured all of that out based on the hint is impressive, as is posting back your solution so thoroughly. Good stuff.

Now I shall go and read about the...

Maybe you could just create a VIEW and use that as your source?

This forum is for questions about SSIS - you should probably post this question here.

SSIS is not good at dynamic columns - you are going to struggle.

In principle, it would be better to marshal all your data together in the SSIS pipeline and then...

Elliott W (4/22/2010)

If a file is copied, its Date...

That's strange.

Something must have changed - you just have to find out what. Source? Target? Windows update? Something else in the package?

I knew I could rely on you ...

As long as they are complete failures and not partial failures ... though I'm quite sure you've got it all handled.

Many people take a...

From Wikipedia:

Staging areas are used in databases as a place to store temporary data for import. By filling this staging tables with import data you can check and alter this...