Let me explain the issue in detail.

This is related to excel data provider problem which I have mentioned in one of my earlier thread. IN excel sheet after 20th row...

I am able to send mail using other services of SQL Server(Using DB Mail), but using SSIS-Send Mail task I am not able to do so.

Thanks,

Is there any other settings required to be done in exchange server, since using sp_send_dbmail I am able to send messages...

I tried both options (Same/different To & Recipeint list)

Thanks,

Thanks Dear, but is there any other way through that we can get error message.

Thanks,

I am sorry...

I repeated almost the same thing which u already made clear in your reply....

my question is to get values for cell which is having more than 255 charecters...

Correction I used MaxScanRows=0

Even for the current post, there is a problem.

If I am getting same type of values for first 8 rows and for next rows (if there...

I also used MaxScanRows=1 in connection string, but still not able to solve the problem(Client does not allow to do registry entry setting).

I went through with this blog also but...

Thanks for the help..It is working perfectly fine...

but I have another question which I have posted already in the forum and may be this information will help me to resolve...

The sample excel file is also attached for refrence.

I have provided just double of the size but OututColumn size is not alowing be to change the value,its fixed even though I have changed Input Column width to allow...

How can we use search string function in SSIS.

Thanks,

Thanks its working...

Nothing special..just wanted to check if there is another workaround

available.

Thanks for the help....

Thanks

Is there any way to implement conditional split using variables. Otherwise I will be required to load data once in a database and then thru looping splitting the records.