HI,

The values for my datetime parameters was July 11th to July14th 2014. It is with in the range of date time parameter only.

Regards,

Prasanna.

I have checked in execution log view. When ever I am getting error, the status of that log is rsHttpRuntimeInternalError.

In package level properties change the property "Delay Validation" to TRUE.

The number of sources will not be constant for each run.............so i think we can't use multiple sources or multiple data flow tasks.............

our requirement is to use SSIS only. Here in the source we are able to select the different excel sheets, but when we are mapping to the destination, only one...

Version of excel is 2007

I too don't know the background of this requirement, one of my colleague is facing this problem....

If the columns in the Sql server Destination table is constant, can we load...

The destination columns will not be constant, it should change according to the columns in the Excel sheet.

Hi Akin,

i have followed all the steps which u have explained, even then i am not able to get my result.

...

Hi Aaron Akin,

I have read your article about "Using EventHandlers with Checkpoints". It is very usefull for me. But OnError eventhandler is not executing for the second time even though...