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.
@@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.
@@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.
@@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.
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 ?
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
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 ' ?
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.
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.
Syntax error in command text, or unsupported SQL construct near term LEFT these error show when we run
Thanks!
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.
@@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.
@@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.
@@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.
Hi
How to write the expression for only get month and year with excle format
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 ?
Hi, How to use a sql 'LIKE 'operator in Conditional Split?
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
@@learnssis Thank you so much
@@zealbehappy5896 You are most welcome.
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 ' ?
You would need to add a single quote after = and before double quote " like below
"ProjectName='" + @[$Project::ProjectName]+"'
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.
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.
Itana fast padaoge to.kisko samj me ayega bhai
Btw thanks..❤❤
Thanks for your suggestion. I will try to improve.
Thanks alot bhaiyya 👍
You are most welcome Suresh.
How to get value start with xx and yy from a column in ssis derived column can you please make video
Okay I will check how we can do that.
Bhaiyya did you make 2nd video for expressions?
Yeah this is the second video on this topic
ruclips.net/video/r9HsJiXnR8k/видео.html
@@learnssis 👍
why are you clicking so fast brother
I am sorry brother, I was not sure if that will make disturbance.
Thanks!
Did you paid ? You don't need to. Thank you so much for being a viewer of this channel. It means a lot.