To quote the OP:

to perform additional steps, where...

I think you can use the 2010 ACE OLE DB driver to read from 2007 workbooks. It's possible you'd have to change the Excel version in the connection string.

In the OLE DB Destination, you won't get Truncation Errors (those are used in the pipeline of the dataflow). If there's a truncation error, it happens in the database engine...

You can use SQLCommand or other relevant classes.

You can install a 32-bit...

Great question Wayne, thanks. Definately learned something.

Great question about a new 2012 feature. Thanks Ron!

(and thanks for including me ;-))

Thanks for the question and thanks to Hugo for his elaborate explanation 🙂

Thanks for the (easy) question.

10e5x (1/9/2013)

Its stored in numerous folder due to requirement. May i know which should package should i identify? the one inside the project folder,...

My guess is that the source is quite slow, hence it can take some time for a buffer to fill. When you make the buffer smaller, it is passed on...

Where is the package stored?

Not sure what this question tries to teach us.

I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I got it...

Can you post the dates?

You can reverse the string, look for the position of the second underscore and take the substring starting from that position till the end. Reverse the substring back and you...