Thanks a lot all for the expert advise and feedbacks.

Thanks and I've tried that and it works for varchar datatype but not for datetime datatype.   REPLACE(COLUMN_NAME, "\"", "")

Thanks Sir but I am using Azure Blob Source and not a flat file connection manager. (I've mentioned that in my post)

Is there any other way to get rid of...

Thanks a lot @heb1014. So When I look at the view it uses around 10 tables join and one of the table has 3 billion rows and uses...

but that's my default constraint. May be I need to define it the other way. Then its working.

ALTER TABLE #temp2 ADD CONSTRAINT DF_lastprocessed DEFAULT GETDATE() FOR lastprocessed

Thanks

Okay Sure. Thanks.

Yes Phil. Authentication part is not an issue at all. It works. Thanks for your help.

Nope, its the same error there too. Trying to fix it but not sure why its not working. if anyone has worked on similar and tell if the syntax is...

Here is the answer I found by myself for anyone out looking there,,,

SELECT ACCOUNT_NO, RATE_PLAN_NO = STUFF((SELECT N', ' + ' U' + CAST(RATE_PLAN_NO  AS VARCHAR)...

Mya be you have some different collation or timezone setting. Here is what I am getting.  6/14/2019 5:00:00 PM

Thanks all. Here is the SSIS expression for those who only need to use SSIS,

DATEADD("hh",17,(DT_DBTIMESTAMP) ( (DT_STR,30,1252) (DT_DBDATE) (DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), getdate()) ) ) )

Thanks Sreedhar... Ur expression works but the variable has datetime datatype so it converts it to 6/7/2019 5:00:00 PM format rather than 2019-06-07 17:00:00.000.  Anyway Thanks for all ur help...

• This reply was modified 5 years, 6 months ago by  dallas13.

Thanks Sreedhar but this is T-SQL Way of doing it and I want it as SSIS expression way.

Yeah. Thats correct Phil.

Thanks Phil.

I have to fetch data only until friday 5 pm. So this expression gives me last friday( i need to remove -1 from my expression) with current timestamp but...