Thanks Doug.Brown, But I'm using NOLOCK in my select query.

Thanks a lot R.P.Rozema...! your query snippet helped a lot to fix the issue.

Thanks for your reply,

we didn't get any specific exception that's why I'm not able to share. while opening it throwing the not able to open the excel.

Client not able to open the download excel sheet, out assumption it's not downloaded properly. Problem we not able replicate in our environment. It happening in their client environmentetwork.

I'm using VS 2008 BIDS.

Thanks Guys for your guidance...

I have overcomes this problem using XQuery functionality.

Yeah.. I tried that too.. but getting the same exception

Yes Evil, 0x+@Column. Currently File is extract with the following data "3C436C696E6963" after DT_Text conversion but it has be prefixed with Hex String 0x3C436C696E6963

Hi Evil,

Thanks for your reply, when i prepend 0x in script it's working. But when i tried the same in SSIS using derived column I'm getting exception(i have attached the...

Hi Kendal Van Dyke,

"How To Get Table Row Counts Quickly And Painlessly" really helpful and crisp snippet to find the rowcount of the table, my doubt while we are...

I Found the solution

declare @STR varchar(1000)

set @STR = 'aSample_1_scrShot_2009-01-02_09-15-51.png^aSample_2_scrShot_2009-01-12_09-00-07.png^ASAMPLE_3_scrShot - _2009-01-23_10-51-19.png^ASAMPLE_4_scrShot_2008-12-31_17-58-17.png^ASAMPLE_5_scrShot_2009-01-02_09-15-06.png^ASAMPLE_6_scrShot - _2009-03-05_09-56-31.png^ASAMPLE_7_scrSht-_2009-04-10_10-37-53.png^'

select REPLACE(@str, 'ASAMPLE_5_scrShot_2009-01-02_09-15-06.png^', '')

Thanks Grant Fritchey & kruti, i Got the solution from your guidance

once again thanks

Hey Lowell & Matt u both rocks,

thanks for your guidance

hi Matt,

thanks for your kind reply,

when i created that function, and executed it like this,

CREATE FUNCTION dbo.testFunction

(@STARTDATE datetime,@EntDt datetime)

RETURNS TABLE

AS

RETURN

with DateList as

(

select cast(@STARTDATE as...

IF object_id('tempdb..#tmpTBL') is not null

DROP TABLE #tmpTBL;

select distinct * into #tmpTBL from exampletable

truncate table exampletable

insert exampletable select * from #tmpTBL ORDER BY Name

drop table #tmpTBL