nice question, Thanks for sharing

you said its not working but you didn't explain whats not working. there is also no sample data from which we can understand the issue. One issue which may raise...

good question. thanks for sharing

nice question. thanks for sharing

Its a validation level issue, means when ssis validate the source connection existence.

Try the Delay Validation property set to 'True'.

what error you are getting?

What is the structure of this table. which columns you are using for the clustered index. (Share the table schema of the table)

How offend you use this data in your...

Go through links provided shared here and hopefully you will find your way out. 🙂

Good question. Nice share

and good point shared by Hugo +1.

please refer to Eirikur response, i need more coffee i guess 🙂

good thoughtful question. really nice share. Thanks

A quick question All these 100 flat files have a single common template (columns and data types). what you want to achieve once this working is done? because there will...

you can store the value of grand total field into a parameter and then use that parameter in your report.

check following link.

Hope it helps.

Nice question Igor, Thanks for sharing