I'm having a huge problem when reading from a csv. I go and edit the C# code and use the output.column0 etc... but after I make a change or I add new columns .. it seems the C# code never recognizes the changes. I rebuild, I build, I clean... There's nothing I can do about 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.
without using code to determine the value, can you use a lookup transformation to check Male/Female against the value in a lookup table and return the numeric value for that row?
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
The major difference between both is that, In Script Component transformation we can write script using C#.NET or VB.NET, while in derived column transformation we can write code in SSIS expression language. Both transformation can be used to add new columns to the data flow and update values in the columns. However you can do a lot more using Script component as compare to Derived column, for example in Script component you can read data from flat file\excel file\sql server\api etc, however you can't do this in derived column transformation. You can only use the functions give by SSIS like date functions (like getdate()), string functions (like substring, replace etc), type cast functions (dt_Wstr etc).
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.
here I made 2 videos where in one video I am logging the error details to a sql table and in another one I am logging the error details to a flat file ruclips.net/video/pmXIbq_U_L0/видео.html ruclips.net/video/-zoNMZtiPBU/видео.html
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.
I'm having a huge problem when reading from a csv. I go and edit the C# code and use the output.column0 etc... but after I make a change or I add new columns .. it seems the C# code never recognizes the changes. I rebuild, I build, I clean... There's nothing I can do about it.
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 ?
what a clear explanation, loved it🤩
Thank you Ashab.
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 !!
without using code to determine the value, can you use a lookup transformation to check Male/Female against the value in a lookup table and return the numeric value for that row?
Yes we can do that as well.
Excellent elaboration of the script shape, thanks.
Thank you Faheem Bhai.
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.
Salam br. Aqil, great work!
Wa alikum asslam. 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.
Amazing video much appreciated brother.
Thank you brother. Thanks.
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
this is very good. thank you
Glad you liked it.
What is the difference between Script component transformation and Derived component transformation ?
The major difference between both is that, In Script Component transformation we can write script using C#.NET or VB.NET, while in derived column transformation we can write code in SSIS expression language.
Both transformation can be used to add new columns to the data flow and update values in the columns. However you can do a lot more using Script component as compare to Derived column, for example in Script component you can read data from flat file\excel file\sql server\api etc, however you can't do this in derived column transformation. You can only use the functions give by SSIS like date functions (like getdate()), string functions (like substring, replace etc), type cast functions (dt_Wstr etc).
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.
How to log the errors in script component
here I made 2 videos where in one video I am logging the error details to a sql table and in another one I am logging the error details to a flat file
ruclips.net/video/pmXIbq_U_L0/видео.html
ruclips.net/video/-zoNMZtiPBU/видео.html
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.
you forgot to output the firstname without "_", but it's a great playlist.
Thanks for pointing that out Selim.
Hi sir it's great vedio but, iam not getting value in gender 1&2
Script is not opening in ssis
You might need to reinstall SSIS.
Thanks
You are most welcome Parveen.
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