To load data from excel, you can use a script task written in .net using excel application component. This way you can use all features of excell, and read data,...

I am not aware of TFS, but basically from any source safe tool, get the latest version of the packages to a stage folder and deploy to production.

Hope you are changing the config file path to new location, in the configuration settings.

You need to write test case for each task that is defined in the package.

Based on the input, the expected result at each task should be validated as part...

Can you please post the data type that you have used in your source and destination tasks ?

Also, ensure that "IMEX=1" is set in the extended properties of excel...

Basically, when an SSIS package executes, it has to create buffers to hold the data for futher processiong, which needs a lot of memory. SSIS run time has to hold...