71 What are expressions in SSIS ? How to write expressions ?

[@pandarikkal]

Thanks!

[@learnssis]

Not sure if you paid ? You actually don't need to. I never get any payment from anyone before you on this channel thus I am not sure. Thank you so much for being a viewer of this channel, you can just support by viewing the videos. You don't need to pay anything.

[@pandarikkal]

​@@learnssis I was just testing the thanks option in the video. Even 1 lakh rupees is not enough to thank you. you are doing such a great help to me. I Admire your knowledge and communication skill. I completed 76 videos of Learn SSIS. Thank you Aqil. Thank you so much.

[@learnssis]

@@pandarikkal No problem, you are most welcome. Its good to know that the videos helped you to learn the SSIS concepts. Thanks for being a subscriber and active member of the channel.

[@learnssis]

@@pandarikkal You are most welcome, but its all your effort to learn the things which are helping you, if you won't try from your end then nobody will be of any help, so its all you who is helping you.

[@arrow94]

Itana fast padaoge to.kisko samj me ayega bhai Btw thanks..❤❤

[@learnssis]

Thanks for your suggestion. I will try to improve.

[@akhtar4970]

Syntax error in command text, or unsupported SQL construct near term LEFT these error show when we run

[@pvksmaheeth8816]

i have a variable called ProjectName = Hello, if I give like this "ProjectName=" + @[$Project::ProjectName] the output is Hello , but i want 'Hello' . How do i get ProjectName= ' Hello ' ?

[@learnssis]

You would need to add a single quote after = and before double quote " like below "ProjectName='" + @[$Project::ProjectName]+"'

[@anushaakkerapu848]

Hi How to write the expression for only get month and year with excle format

[@learnssis]

Do you want to get the month and year from excel file path or want to get it from current month and current year ? In in which format you need it ? Do you want to get both separately or concatenated ?

[@omkarsaste6998]

Hi, How to use a sql 'LIKE 'operator in Conditional Split?

[@learnssis]

You can use FindString for this one. Take a look at this URL stackoverflow.com/questions/4739230/is-it-possible-to-perform-a-like-statement-in-a-ssis-expression

[@zealbehappy5896]

@@learnssis Thank you so much

[@learnssis]

@@zealbehappy5896 You are most welcome.

[@sureshareti2843]

Thanks alot bhaiyya 👍

[@learnssis]

You are most welcome Suresh.

[@akhtar4970]

Hi, Please make one video on same concept for SAP Data source. I want to write query for selecting first 4 character from column in SAP data source dynamically. i have used Substring and right but these are not supported. so please help me out.

[@learnssis]

Hi Akhtar, I don't think we have SAP data source in SSIS. Also I don't have experience working with SAP and neither I have SAP installed anywhere so that I can test it. I think there are some ODBC drivers those you can install for getting data from SAP, but if you use the ODBC source then you can't write the dynamic query in source.

[@sureshareti2843]

Bhaiyya did you make 2nd video for expressions?

[@learnssis]

Yeah this is the second video on this topic kzbin.info/www/bejne/qGqrpH2fjdOFbs0

[@sureshareti2843]

@@learnssis 👍

[@arrow94]

How to get value start with xx and yy from a column in ssis derived column can you please make video

[@learnssis]

Okay I will check how we can do that.

[@alsafisiddig6201]

why are you clicking so fast...do you repeat this video because there is more complaint

[@PavanKalyan-oj6dl]

why are you clicking so fast brother

[@learnssis]

I am sorry brother, I was not sure if that will make disturbance.

[@pandarikkal]

Thanks!

[@learnssis]

Did you paid ? You don't need to. Thank you so much for being a viewer of this channel. It means a lot.