Hi great video, can you advise how to take buffer as an input and spit out the columns according to a certain column into multiple tabs in an excel file. Thank you.
Hi , Can you please clarify my doubt can we do script component dynamically like having 5 table with different columns need to work with one script component dynamically ? Can be able to implement that ?
Hi, thank you it is helpful, however can u tell me how can I read the whole row in script component, my requirement is to remove the unnecessary special characters from the line and process it to ole db.
Take a look at this blog, it might be helpful to you. stackoverflow.com/questions/10387550/how-do-i-remove-spaces-while-importing-flat-file-containing-intermediate-blank-l
All this can be done in derived column transformation of SSIS. Would be great if you do some complex transformations which can only be done by Script Component.
@Mohammad Zaman Yeah we can write a complex stuff inside the if else statement. I just tried to make the example easy so that everyone can understand it.
@@amanahmed6057 we just added a new column to show you that we can add multiple columns in the data flow. If you do not want to add Gender1 then it's totally fine.
Do you mean the data in flat file will come from 2 different tables ? At the end there will only be a single file in flat file. Unalike to excel file where we can have multiple sheets in a single file, we can't have multiple sheets in flat file.
@@karthikkunala Hi Karthik, I have not created videos on third party components but yes they are trust worthy and for most of the components we would need to purchase license to use them. For example we have components those pull data from Quickbooks to sql and vice versa. There are components which can do incremental load, so they works fine but you would need to pay for them.
Excellent elaboration of the script shape, thanks.
Thank you Faheem Bhai.
what a clear explanation, loved it🤩
Thank you Ashab.
Hi great video, can you advise how to take buffer as an input and spit out the columns according to a certain column into multiple tabs in an excel file. Thank you.
Thank you very much. This is very helpful.
Thank you Gihan for your comment. Its nice to hear that you liked the video.
Hi sir,
I need to get the values that are populated in script component inside data flow task to the pacakage variable how to do ?
Salam br. Aqil, great work!
Wa alikum asslam. Thank you.
Amazing video much appreciated brother.
Thank you brother. Thanks.
this is very good. thank you
Glad you liked it.
you forgot to output the firstname without "_", but it's a great playlist.
Thanks for pointing that out Selim.
Hi ,
Can you please clarify my doubt can we do script component dynamically like having 5 table with different columns need to work with one script component dynamically ? Can be able to implement that ?
You can't map the columns dynamically in script component.
Hi, thank you it is helpful, however can u tell me how can I read the whole row in script component, my requirement is to remove the unnecessary special characters from the line and process it to ole db.
Take a look at this blog, it might be helpful to you.
stackoverflow.com/questions/10387550/how-do-i-remove-spaces-while-importing-flat-file-containing-intermediate-blank-l
All this can be done in derived column transformation of SSIS. Would be great if you do some complex transformations which can only be done by Script Component.
Thanks for your suggestion, I will try to make a video as per your suggestion.
@Mohammad Zaman Yeah we can write a complex stuff inside the if else statement. I just tried to make the example easy so that everyone can understand it.
10:41
Where you use
Row.Gender1
You didn't use than why you created,
Could you help me related that.
12:07 if you look at this moment we are using Gender1 as Input column which is getting mapped to Gender1 in the sql table.
@@learnssis Thanks but I am confuse why we made Row.Gender1 !
@@amanahmed6057 we just added a new column to show you that we can add multiple columns in the data flow. If you do not want to add Gender1 then it's totally fine.
@@learnssis Copy that !!
Hi sir it's great vedio but, iam not getting value in gender 1&2
How to create a flat file having two tables in it?
Do you mean the data in flat file will come from 2 different tables ? At the end there will only be a single file in flat file. Unalike to excel file where we can have multiple sheets in a single file, we can't have multiple sheets in flat file.
Thanks
You are most welcome Parveen.
Script is not opening in ssis
You might need to reinstall SSIS.
Please explain third-party SSIS components
Sure Parveen Darbar.
@@learnssis sir am
waiting
@@darbardarbar9460 Okay, will make a video on this one soon.
@@learnssis Hello Akhil, any videos you made for 3rd party SSIS components? are they trust worthy?
@@karthikkunala Hi Karthik, I have not created videos on third party components but yes they are trust worthy and for most of the components we would need to purchase license to use them.
For example we have components those pull data from Quickbooks to sql and vice versa. There are components which can do incremental load, so they works fine but you would need to pay for them.
Can u copy the code
Thanks, I have uploaded the code to google drive.
Today I sent a mail to you can you please check it once