That is the normal way how i test too. But since we follow all the processes in this project, I need to prepare test cases for unti testing and integration...

In my local machine, i am using SQL Authentication.

Running the package manually from BIDS.

I am just setting my password presently in my connection managers,package configurations are not enabled.

Yes,I've saved the...

Also, suppose v have to count the files that need to be read at one time. Then how do v count how many files are read in the For Each...

Using the For Each container seems like a good idea. But How do i schedule it such that some files are read at one time and the others at some...