No video :(

37 Script Component Transformation in SSIS

Подписаться 33 тыс.

Просмотров 30 тыс.

50% 1

Script Component Transformation in SSIS | Script Component Transformation
Download the file\script used in the Video from below link
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
script component transformation in ssis
What is script Component transformation in SSIS?
How do I use script component as a source in SSIS?
What is script component?
What is difference between script task and script component?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”

Опубликовано:

6 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 45

@faheemiqbal3865 5 месяцев назад

Excellent elaboration of the script shape, thanks.

@learnssis 5 месяцев назад

Thank you Faheem Bhai.

@ashabhumza3394 6 месяцев назад

what a clear explanation, loved it🤩

@learnssis 6 месяцев назад

Thank you Ashab.

@amrselim2167 9 месяцев назад

you forgot to output the firstname without "_", but it's a great playlist.

@learnssis 9 месяцев назад

Thanks for pointing that out Selim.

@sdang003 4 года назад

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.

@sasisviewvlog Год назад

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 ?

@gihanprabudda7313 7 лет назад

Thank you very much. This is very helpful.

@learnssis 7 лет назад

Thank you Gihan for your comment. Its nice to hear that you liked the video.

@jewelc2770 Год назад

Salam br. Aqil, great work!

@learnssis Год назад

Wa alikum asslam. Thank you.

@KalugampitiyaJayakody 7 лет назад

this is very good. thank you

@learnssis 7 лет назад

Glad you liked it.

@srinumadiraju 5 лет назад

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.

@learnssis 5 лет назад

Thanks for your suggestion, I will try to make a video as per your suggestion.

@learnssis 3 года назад

@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.

@premjitchowdhury262 3 года назад

Amazing video much appreciated brother.

@learnssis 3 года назад

Thank you brother. Thanks.

@darbardarbar9460 2 года назад

Thanks

@learnssis 2 года назад

You are most welcome Parveen.

@gayathriarras6506 Год назад

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 ?

@learnssis Год назад

You can't map the columns dynamically in script component.

@thee_draagon 4 года назад

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.

@learnssis 4 года назад

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

@amanahmed6057 Год назад

10:41 Where you use Row.Gender1 You didn't use than why you created, Could you help me related that.

@learnssis Год назад

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.

@amanahmed6057 Год назад

@@learnssis Thanks but I am confuse why we made Row.Gender1 !

@learnssis Год назад

@@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.

@amanahmed6057 Год назад

@@learnssis Copy that !!

@vinuthackgowda4183 3 года назад

Hi sir it's great vedio but, iam not getting value in gender 1&2

@zeeshanahmad-pg6rs 3 года назад

How to create a flat file having two tables in it?

@learnssis 3 года назад

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.

@kunchapusrikanth4919 Год назад

Today I sent a mail to you can you please check it once

@darbardarbar9460 2 года назад

Please explain third-party SSIS components

@learnssis 2 года назад

Sure Parveen Darbar.

@darbardarbar9460 2 года назад

@@learnssis sir am waiting

@learnssis 2 года назад

@@darbardarbar9460 Okay, will make a video on this one soon.

@karthikkunala 2 года назад

@@learnssis Hello Akhil, any videos you made for 3rd party SSIS components? are they trust worthy?

@learnssis 2 года назад

@@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.