Its a useful feature. Happy learning!

Create a SSIS variable and build an expression and use appropriate CAST functions

Why are you not using SSIS functions for date expressions?

You can design Role Playing Dimensions. Read here:

http://technet.microsoft.com/en-us/library/ms174487(v=sql.90).aspx

The SSIS way is the way to go!

What is the need to create a formatted measure in the cube. If you have data available as seconds you can easily cast the value as HH:MM:SS in the SSRS...

You can create Actions in the SSRS report for this feature.

http://www.katieandemil.com/ssrs-action-go-to-report-with-parameters-drill-down-example

As Phil has already answered, there is an option called as "IsSourceConnectionVariable", set this as true and assign the variable name as the one holding the file name.

Here is...

The first 1100+ rows are loaded with no errors. Can you please analyze the issue with the row(s) which are failing?

Can you see all the columns in the file along with the header names?

As a good practice, you should use the Preview command while configuing the connection manager and tasks? What is the issue with Billing Date Column? It says missing column delimiter?

Can you post the error message here? How are you configuring the Flat File Connection Manager and why does the component throws error? Can you post a sample data with...

TFS is a great tool for source code version management but again TFS inherently would not serve your second requirement. You can fetch this data by querying the reporting services...

Use a Flat File Connection Manager.

http://msdn.microsoft.com/en-us/library/ms140266.aspx

http://technet.microsoft.com/en-us/library/ms141668.aspx

http://technet.microsoft.com/en-us/library/ms139941.aspx

Gave a thought to this and a solution what i have in mind is to insert file name and location in a table while genrating the file (BCP) and then...